Re: cross-table unique constraint

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Randall Smith <randall(at)tnr(dot)cc>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: cross-table unique constraint
Date: 2004-01-09 04:13:48
Message-ID: 20040109041348.GB31586@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Jan 06, 2004 at 07:10:28 +0000,
Randall Smith <randall(at)tnr(dot)cc> wrote:
> Is it possible to create a unique constraint on multiple fields in
> related tables?

Not with the normal UNIQUE constraint. That will do multiple columns in
one table, but won't span tables.

You can probably do what you want using triggers.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruno Wolff III 2004-01-09 04:16:37 Re: Simulation output using libpq
Previous Message Christopher Browne 2004-01-09 04:05:28 Re: Natural upgrade path for RedHat 9?