From 17d5945331b6d6e80b71b74b1b8ed80f6ddf0f14 Mon Sep 17 00:00:00 2001
From: Pavan Deolasee
Date: Thu, 25 Jun 2015 12:06:20 +0530
Subject: Change expected output for the test case 'tablespace'

We don't yet support CREATE TABLE AS EXECUTE. So the expected output is changed
to have the corresponding error message and side effects of the same
---
 src/test/regress/output/tablespace.source | 11 +++++------
 1 file changed, 5 insertions(+), 6 deletions(-)

(limited to 'src')

diff --git a/src/test/regress/output/tablespace.source b/src/test/regress/output/tablespace.source
index ca606508f8..d79f71e3dd 100644
--- a/src/test/regress/output/tablespace.source
+++ b/src/test/regress/output/tablespace.source
@@ -45,12 +45,12 @@ SELECT relname, spcname FROM pg_catalog.pg_tablespace t, pg_catalog.pg_class c
 PREPARE selectsource(int) AS SELECT $1;
 CREATE TABLE testschema.asexecute TABLESPACE testspace
     AS EXECUTE selectsource(2);
+ERROR:  CREATE TABLE AS EXECUTE not yet supported
 SELECT relname, spcname FROM pg_catalog.pg_tablespace t, pg_catalog.pg_class c
     where c.reltablespace = t.oid AND c.relname = 'asexecute';
-  relname  |  spcname  
------------+-----------
- asexecute | testspace
-(1 row)
+ relname | spcname 
+---------+---------
+(0 rows)
 
 -- index
 CREATE INDEX foo_idx on testschema.foo(i) TABLESPACE testspace;
@@ -101,10 +101,9 @@ NOTICE:  no matching relations in tablespace "testspace_renamed" found
 -- Should succeed
 DROP TABLESPACE testspace_renamed;
 DROP SCHEMA testschema CASCADE;
-NOTICE:  drop cascades to 4 other objects
+NOTICE:  drop cascades to 3 other objects
 DETAIL:  drop cascades to table testschema.foo
 drop cascades to table testschema.asselect
-drop cascades to table testschema.asexecute
 drop cascades to table testschema.atable
 DROP ROLE tablespace_testuser1;
 DROP ROLE tablespace_testuser2;
-- 
cgit v1.2.3