diff options
| author | Alvaro Herrera | 2015-03-18 17:48:02 +0000 |
|---|---|---|
| committer | Alvaro Herrera | 2015-03-18 17:48:02 +0000 |
| commit | b8d226b4f9691c7afb986dbaaf3f6ff7b203d1b5 (patch) | |
| tree | 22edcc6d4eb91685d02d0bdb8421523ecd85cb99 /src/test | |
| parent | 0d831389749a3baaced7b984205b9894a82444b9 (diff) | |
Setup cursor position for schema-qualified elements
This makes any errors thrown while looking up such schemas report the
position of the error.
Author: Ryan Kelly
Reviewed by: Jeevan Chalke, Tom Lane
Diffstat (limited to 'src/test')
| -rw-r--r-- | src/test/regress/expected/create_table.out | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/src/test/regress/expected/create_table.out b/src/test/regress/expected/create_table.out index 35451d5af26..34b5fc113d0 100644 --- a/src/test/regress/expected/create_table.out +++ b/src/test/regress/expected/create_table.out @@ -212,11 +212,15 @@ INSERT INTO unlogged1 VALUES (42); CREATE UNLOGGED TABLE public.unlogged2 (a int primary key); -- also OK CREATE UNLOGGED TABLE pg_temp.unlogged3 (a int primary key); -- not OK ERROR: only temporary relations may be created in temporary schemas +LINE 1: CREATE UNLOGGED TABLE pg_temp.unlogged3 (a int primary key); + ^ CREATE TABLE pg_temp.implicitly_temp (a int primary key); -- OK CREATE TEMP TABLE explicitly_temp (a int primary key); -- also OK CREATE TEMP TABLE pg_temp.doubly_temp (a int primary key); -- also OK CREATE TEMP TABLE public.temp_to_perm (a int primary key); -- not OK ERROR: cannot create temporary relation in non-temporary schema +LINE 1: CREATE TEMP TABLE public.temp_to_perm (a int primary key); + ^ DROP TABLE unlogged1, public.unlogged2; CREATE TABLE as_select1 AS SELECT * FROM pg_class WHERE relkind = 'r'; CREATE TABLE as_select1 AS SELECT * FROM pg_class WHERE relkind = 'r'; |
