Re: Foreign Unique Constraint

[chester c young <chestercyoung(at)yahoo(dot)com>]

> 
> create table table1 (
> id SERIAL PRIMARY KEY
> extension UNIQUE,
> <other fields>
> )
> 
> create table table2 (
> id SERIAL PRIMARY KEY
> extension UNIQUE,
> <different fields>
> )
> 
> Basically table 1 and table 2 both have the concept of an extension
> that must be unique but the rest of the info in the tables are
> different.  I need to ensure that if i add an entry to table 1 with
> extension 1000 that it will fail if there is already an entry in
> table2 with the same extension.

use a pre-insert triggers - one for each table.  include something like

if exists( select 1 from table2 where extension=new.extension ) then
  raise exception ...
end if;




 
____________________________________________________________________________________
Expecting? Get great news right away with email Auto-Check. 
Try the Yahoo! Mail Beta.
http://advision.webevents.yahoo.com/mailbeta/newmail_tools.html