Code: Select all
dbadmin=> create table s (s1 int not null);
CREATE TABLE
dbadmin=> alter table s add constraint pk1 primary key (s1);
ALTER TABLE
dbadmin=> alter table s add constraint pk2 primary key (s1);
ROLLBACK 4413: Primary constraint for relation "s" already exists
Code: Select all
dbadmin=> alter table s add constraint uk1 unique (s1);
ALTER TABLE
dbadmin=> alter table s add constraint uk2 unique (s1);
ALTER TABLE
dbadmin=> alter table s add constraint uk3 unique (s1);
ALTER TABLE