Re: [GENERAL] unique constraint on more than one tables

2006-12-28 Thread George Pavlov
nodupes before insert on bla_b for each row execute procedure tf_nodupes(); > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Akbar > Sent: Thursday, December 28, 2006 4:01 AM > To: pgsql-general@postgresql.org > Subje

[GENERAL] unique constraint on more than one tables

2006-12-28 Thread Akbar
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