Hi, Imagine I have two tables, like this:
create table bla_a ( id serial primary key, name varchar(31) not null, comment varchar(31) ); create table bla_b ( id serial primary key, name varchar(31) not null, blabla int ); I want to make sure that both tables could not have the same value for name column. Can I do that? insert into bla_a ( id, name, comment ) values ( 1, 'bo', 'ha'); insert into bla_b ( id, name, comment ) values ( 1, 'bo', 3); I want to make the second insertion failed because of unique constraint. Can I do that? ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
