Re: custom integrity check

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Abdul-Wahid Paterson <abdulwahid(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: custom integrity check
Date: 2005-01-21 12:52:00
Message-ID: 200501211352.01319.peter_e@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Am Freitag, 21. Januar 2005 12:58 schrieb Abdul-Wahid Paterson:
> I have the following table as a link table between my 'cats' table and
> my 'items' table. Every item must have at least one cat and exactly
> one 'master' cat.
>
> How can I create an integrity check to make sure that each item has
> exactly one 'master' cat.

It seems to me that you should merge this table into the "cats" table.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Sean Davis 2005-01-21 13:09:22 tsearch2 dump and restore
Previous Message Wes 2005-01-21 12:45:10 Re: Shared memory and Mac OS X