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