From: Rodger Donaldson <rodgerd@diaspora.gen.nz>
To: pgsql-sql@postgresql.org
Subject: Cross-table constraints
Date: Tue, 28 Jan 2003 20:05:15 +1300
Message-ID: <20030128070514.GB7146@diaspora.gen.nz> (raw)
The problem: I have two tables, add_queue and sites, on a postgresql
7.2.x database. add_queue is where items go to be reviewed by a human
before being moved into sites. One of the things I'd like to do is to
cut down on the amount of work done by humans filtering out dupes and
sundry other problems.
I'd prefer to keep the logic entirely within the DB, rather than on
the client side, to make it consistent across the various interfaces
into add_queue.
Now, adding a UNIQUE constraint on the pk for add_queue weeds out
dupes there. However, attempting to add a cross-table UNIQUE check
with:
alter table add_queue add constraint add_queue_no_dupe_sites unique
(sites.url);
ERROR: parser: parse error at or near "."
,,,fails. Foreign key constraints will only require a match (of one
sort or another) in the foreign table, according to the postgresql 7.2
documentation, and do not have an option to require no match.
Am I missing something obvious (syntax for UNIQUE, for example), or
trying to do something that just doesn't work that way?
--
Rodger Donaldson rodgerd@diaspora.gen.nz
"How do I set my laser printer for stun?"
-- William Tansil
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: rodgerd@diaspora.gen.nz
Subject: Re: Cross-table constraints
In-Reply-To: <20030128070514.GB7146@diaspora.gen.nz>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox