diff options
Diffstat (limited to 'src/test/regress/sql')
-rw-r--r-- | src/test/regress/sql/alter_table.sql | 8 | ||||
-rw-r--r-- | src/test/regress/sql/copy2.sql | 2 | ||||
-rw-r--r-- | src/test/regress/sql/create_table.sql | 4 | ||||
-rw-r--r-- | src/test/regress/sql/errors.sql | 3 |
4 files changed, 7 insertions, 10 deletions
diff --git a/src/test/regress/sql/alter_table.sql b/src/test/regress/sql/alter_table.sql index 6b94e14ec85..e6be119ff7d 100644 --- a/src/test/regress/sql/alter_table.sql +++ b/src/test/regress/sql/alter_table.sql @@ -348,7 +348,7 @@ drop table atacc1; -- test unique constraint adding -create table atacc1 ( test int ); +create table atacc1 ( test int ) with oids; -- add a unique constraint alter table atacc1 add constraint atacc_test1 unique (test); -- insert first value @@ -402,7 +402,7 @@ drop table atacc1; -- test primary key constraint adding -create table atacc1 ( test int ); +create table atacc1 ( test int ) with oids; -- add a primary key constraint alter table atacc1 add constraint atacc_test1 primary key (test); -- insert first value @@ -485,7 +485,7 @@ alter table non_existent alter column bar drop not null; -- test setting columns to null and not null and vice versa -- test checking for null values and primary key -create table atacc1 (test int not null); +create table atacc1 (test int not null) with oids; alter table atacc1 add constraint "atacc1_pkey" primary key (test); alter table atacc1 alter column test drop not null; alter table atacc1 drop constraint "atacc1_pkey"; @@ -582,7 +582,7 @@ alter table pg_class drop column relname; alter table nosuchtable drop column bar; -- test dropping columns -create table atacc1 (a int4 not null, b int4, c int4 not null, d int4); +create table atacc1 (a int4 not null, b int4, c int4 not null, d int4) with oids; insert into atacc1 values (1, 2, 3, 4); alter table atacc1 drop a; alter table atacc1 drop a; diff --git a/src/test/regress/sql/copy2.sql b/src/test/regress/sql/copy2.sql index 70c8ea6b1e8..78bbf4182e5 100644 --- a/src/test/regress/sql/copy2.sql +++ b/src/test/regress/sql/copy2.sql @@ -4,7 +4,7 @@ CREATE TABLE x ( c text not null default 'stuff', d text, e text -); +) WITH OIDS; CREATE FUNCTION fn_x_before () RETURNS TRIGGER AS ' BEGIN diff --git a/src/test/regress/sql/create_table.sql b/src/test/regress/sql/create_table.sql index b6a0a8fe603..b5a2889f374 100644 --- a/src/test/regress/sql/create_table.sql +++ b/src/test/regress/sql/create_table.sql @@ -51,7 +51,7 @@ CREATE TABLE tenk1 ( stringu1 name, stringu2 name, string4 name -); +) WITH OIDS; CREATE TABLE tenk2 ( unique1 int4, @@ -83,7 +83,7 @@ CREATE TABLE person ( CREATE TABLE emp ( salary int4, manager name -) INHERITS (person); +) INHERITS (person) WITH OIDS; CREATE TABLE student ( diff --git a/src/test/regress/sql/errors.sql b/src/test/regress/sql/errors.sql index 630e49024d5..5ccd13bbe52 100644 --- a/src/test/regress/sql/errors.sql +++ b/src/test/regress/sql/errors.sql @@ -10,9 +10,6 @@ select 1; -- UNSUPPORTED STUFF -- doesn't work --- attachas nonesuch --- --- doesn't work -- notify pg_class -- |