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

1 files changed, 5 insertions, 6 deletions

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;