elog(ERROR,"%s: failed to make implicit index name",

cxt->stmtType);

elog(NOTICE,"%s / %s will create implicit index '%s' for table '%s'",

cxt->stmtType, (index->primary ?"PRIMARY KEY" :"UNIQUE"),

elog(NOTICE,"%s / %s%s will create implicit index '%s' for table '%s'",

cxt->stmtType,

(strcmp(cxt->stmtType,"ALTER TABLE")==0) ?"ADD " :"",

(index->primary ?"PRIMARY KEY" :"UNIQUE"),

index->idxname,cxt->relname);

}

}

create table atacc1 ( test int );

-- add a unique constraint

alter table atacc1 add constraint atacc_test1 unique (test);

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

NOTICE: ALTER TABLE /ADDUNIQUE will create implicit index 'atacc_test1' for table 'atacc1'

-- insert first value

insert into atacc1 (test) values (2);

-- should fail

insert into atacc1 (test) values (4);

-- try adding a unique oid constraint

alter table atacc1 add constraint atacc_oid1 unique(oid);

NOTICE: ALTER TABLE / UNIQUE will create implicit index 'atacc_oid1' for table 'atacc1'

NOTICE: ALTER TABLE /ADDUNIQUE will create implicit index 'atacc_oid1' for table 'atacc1'

drop table atacc1;

-- let's do one where the unique constraint fails when added

create table atacc1 ( test int );

insert into atacc1 (test) values (2);

-- add a unique constraint (fails)

alter table atacc1 add constraint atacc_test1 unique (test);

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

NOTICE: ALTER TABLE /ADDUNIQUE will create implicit index 'atacc_test1' for table 'atacc1'

ERROR: Cannot create unique index. Table contains non-unique values

insert into atacc1 (test) values (3);

drop table atacc1;

create table atacc1 ( test int, test2 int);

-- add a unique constraint

alter table atacc1 add constraint atacc_test1 unique (test, test2);

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

NOTICE: ALTER TABLE /ADDUNIQUE will create implicit index 'atacc_test1' for table 'atacc1'

-- insert initial value

insert into atacc1 (test,test2) values (4,4);

-- should fail

create table atacc1 (test int, test2 int, unique(test));

NOTICE: CREATE TABLE / UNIQUE will create implicit index 'atacc1_test_key' for table 'atacc1'

alter table atacc1 add unique (test2);

NOTICE: ALTER TABLE / UNIQUE will create implicit index 'atacc1_test2_key' for table 'atacc1'

NOTICE: ALTER TABLE /ADDUNIQUE will create implicit index 'atacc1_test2_key' for table 'atacc1'

-- should fail for @@ second one @@

insert into atacc1 (test2, test) values (3, 3);

insert into atacc1 (test2, test) values (2, 3);