Re: Foreign Unique Constraint

am  Tue, dem 27.03.2007, um  9:21:44 -0400 mailte Jon Horsman folgendes:
> I was wondering if someone could help point me in the right direction
> w.r.t. foreign unique constraints.  I'm working on a legacy database
> and have a new requirement and am not sure how to do it.
> 
> I have something like this
> 
> create table table1 (
> id SERIAL PRIMARY KEY
> extension UNIQUE,

I can't find anything about this syntax in the docs...

> 
> 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.

I think, you should write a TRIGGER for this.


Andreas
-- 
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net