drop table atacc2;

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);

NOTICE: ALTER TABLE / ADD UNIQUE will create implicit index "atacc_test1" for table "atacc1"

ERROR: duplicate key violates unique constraint "atacc1_test_key"

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);

NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "atacc_test1" for table "atacc1"

ERROR: relation "non_existent" does not exist

-- 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);

NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "atacc1_pkey" for table "atacc1"

alter table atacc1 alter column test drop not null;

alter table nosuchtable drop column bar;

ERROR: relation "nosuchtable" does not exist

-- 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;

c text not null default 'stuff',

d text,

e text

);

) WITH OIDS;

NOTICE: CREATE TABLE will create implicit sequence "x_a_seq" for serial column "x.a"

CREATE FUNCTION fn_x_before () RETURNS TRIGGER AS '

BEGIN

stringu1name,

stringu2name,

string4name

);

) WITH OIDS;

CREATE TABLE tenk2 (

unique1 int4,

unique2 int4,

CREATE TABLE emp (

salary int4,

manager name

) INHERITS (person);

) INHERITS (person) WITH OIDS;

CREATE TABLE student (

gpa float8

) INHERITS (person);

--

-- UNSUPPORTED STUFF

-- doesn't work

-- attachas nonesuch

--

-- doesn't work

-- notify pg_class

--

createtableatacc1 ( testint );

createtableatacc1 ( testint ) with oids;

altertable atacc1 addconstraint atacc_test1 unique (test);

createtableatacc1 ( testint );

createtableatacc1 ( testint ) with oids;

altertable atacc1 addconstraint atacc_test1primary key (test);

createtableatacc1 (testintnot null);

createtableatacc1 (testintnot null) with oids;

altertable atacc1 addconstraint"atacc1_pkey"primary key (test);

altertable atacc1 alter column test dropnot null;

altertable atacc1 dropconstraint"atacc1_pkey";

altertable nosuchtable drop column bar;

createtableatacc1 (a int4not null, b int4, c int4not null, d int4);

createtableatacc1 (a int4not null, b int4, c int4not null, d int4) with oids;

insert into atacc1values (1,2,3,4);

altertable atacc1 drop a;

altertable atacc1 drop a;

ctextnot null default'stuff',

dtext,

etext

);

) WITH OIDS;

CREATEFUNCTIONfn_x_before () RETURNS TRIGGERAS'

stringu1name,

stringu2name,

string4name

);

) WITH OIDS;

CREATETABLEtenk2 (

unique1 int4,

CREATETABLEemp (

salary int4,

manager name

) INHERITS (person);

) INHERITS (person) WITH OIDS;

CREATETABLEstudent (