Re: Inheritance foreign key unexpected behaviour

From: Scott Ribe <scott_ribe(at)killerbytes(dot)com>
To: "M(dot) van Egmond" <mvanegmond(at)quetalzorg(dot)nl>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: Inheritance foreign key unexpected behaviour
Date: 2007-10-22 18:31:57
Message-ID: C34248BD.8366E%scott_ribe@killerbytes.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

PostgreSQL foreign keys won't enforce restrictions the way you want them to;
you'll have to use a trigger. And at that point, you might as well consider
alternative designs...

--
Scott Ribe
scott_ribe(at)killerbytes(dot)com
http://www.killerbytes.com/
(303) 722-0567 voice

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Florian Weimer 2007-10-22 18:48:34 Re: [HACKERS] 8.2.3: Server crashes on Windows using Eclipse/Junit
Previous Message Martin Marques 2007-10-22 18:31:01 Re: Bitmap Heap scan 8.1/8.2