diff options
| author | Simon Riggs | 2012-06-09 15:35:26 +0000 |
|---|---|---|
| committer | Simon Riggs | 2012-06-09 15:35:26 +0000 |
| commit | 72335a20156b19be3a53ef686e0b31140c6f38e5 (patch) | |
| tree | 67673c25e638eebe6a3c3cbff8f25621aefc9613 /src/test | |
| parent | 37255705399b57b2e413814799f0bc9b94fda14a (diff) | |
Add ERROR msg for GLOBAL/LOCAL TEMP is not yet implemented
Diffstat (limited to 'src/test')
| -rw-r--r-- | src/test/regress/expected/create_table.out | 16 | ||||
| -rw-r--r-- | src/test/regress/sql/create_table.sql | 5 |
2 files changed, 21 insertions, 0 deletions
diff --git a/src/test/regress/expected/create_table.out b/src/test/regress/expected/create_table.out index d20790f9098..0b2cbc734a8 100644 --- a/src/test/regress/expected/create_table.out +++ b/src/test/regress/expected/create_table.out @@ -220,3 +220,19 @@ NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "doubly_temp_pkey CREATE TEMP TABLE public.temp_to_perm (a int primary key); -- not OK ERROR: cannot create temporary relation in non-temporary schema DROP TABLE unlogged1, public.unlogged2; +CREATE GLOBAL TEMPORARY TABLE global_temp1 (a int, b text); -- not yet OK +ERROR: GLOBAL TEMPORARY not yet implemented +LINE 1: CREATE GLOBAL TEMPORARY TABLE global_temp1 (a int, b text); + ^ +CREATE GLOBAL TEMP TABLE global_temp2 (a int, b text); -- not yet OK +ERROR: GLOBAL TEMPORARY not yet implemented +LINE 1: CREATE GLOBAL TEMP TABLE global_temp2 (a int, b text); + ^ +CREATE LOCAL TEMP TABLE local_temp (a int, b text); -- not yet OK +ERROR: LOCAL TEMPORARY not yet implemented +LINE 1: CREATE LOCAL TEMP TABLE local_temp (a int, b text); + ^ +CREATE LOCAL TEMP TABLE local_temp (a int, b text); -- not yet OK +ERROR: LOCAL TEMPORARY not yet implemented +LINE 1: CREATE LOCAL TEMP TABLE local_temp (a int, b text); + ^ diff --git a/src/test/regress/sql/create_table.sql b/src/test/regress/sql/create_table.sql index a050e8b6d1a..ab0145531cf 100644 --- a/src/test/regress/sql/create_table.sql +++ b/src/test/regress/sql/create_table.sql @@ -250,3 +250,8 @@ 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 DROP TABLE unlogged1, public.unlogged2; + +CREATE GLOBAL TEMPORARY TABLE global_temp1 (a int, b text); -- not yet OK +CREATE GLOBAL TEMP TABLE global_temp2 (a int, b text); -- not yet OK +CREATE LOCAL TEMP TABLE local_temp (a int, b text); -- not yet OK +CREATE LOCAL TEMP TABLE local_temp (a int, b text); -- not yet OK |