Unbreak unlogged tables.

[postgresql] / src / test / regress / expected / create_table.out

diff --git a/src/test/regress/expected/create_table.out b/src/test/regress/expected/create_table.out
index 62010a14821a7a2f51f7d6335fa4f1a1997f86da..b1dedd469d77163cc51f93bbe7f0c422199879d6 100644 (file)
--- a/src/test/regress/expected/create_table.out
+++ b/src/test/regress/expected/create_table.out
@@ -204,3 +204,14 @@ CREATE TABLE IF NOT EXISTS test_tsvector(
        t text
 );
 NOTICE:  relation "test_tsvector" already exists, skipping
+CREATE UNLOGGED TABLE unlogged1 (a int);                       -- OK
+INSERT INTO unlogged1 VALUES (42);
+CREATE UNLOGGED TABLE public.unlogged2 (a int);                -- also OK
+CREATE UNLOGGED TABLE pg_temp.unlogged3 (a int);       -- not OK
+ERROR:  only temporary relations may be created in temporary schemas
+CREATE TABLE pg_temp.implicity_temp (a int);           -- OK
+CREATE TEMP TABLE explicitly_temp (a int);                     -- also OK
+CREATE TEMP TABLE pg_temp.doubly_temp (a int);         -- also OK
+CREATE TEMP TABLE public.temp_to_perm (a int);         -- not OK
+ERROR:  cannot create temporary relation in non-temporary schema
+DROP TABLE unlogged1, public.unlogged2;