Date: Tue, 27 Mar 2007 15:36:42 +0200
From: "A. Kretschmer" <andreas.kretschmer@schollglas.com>
To: pgsql-sql@postgresql.org
Subject: Re: Foreign Unique Constraint
Message-ID: <20070327133642.GB19137@a-kretschmer.de>
References: <4f4c2a010703270621h5137a4e5rb515a9be9034a543@mail.gmail.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <4f4c2a010703270621h5137a4e5rb515a9be9034a543@mail.gmail.com>
User-Agent: Mutt/1.5.9i

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