More FK constraint stuff

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: pgsql-patches(at)postgresql(dot)org
Subject: More FK constraint stuff
Date: 2000-08-20 18:19:56
Message-ID: Pine.BSF.4.10.10008201116410.13545-200000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches


This is mostly the same as an earlier patch I
didn't hear anything about, but which would
have broken with the function manager changes
anyway.

Well, this patch checks that a unique constraint
of some form (unique or pk) is on the referenced
columns of an FK constraint and that the columns
in the referencing table exist at creation time.
The former is to move closer to SQL compatibility
and the latter is in answer to a bug report.
I also added a basic check of this functionality
to the alter table and foreign key regression
tests.

Stephan Szabo
sszabo(at)bigpanda(dot)com

Attachment Content-Type Size
fk3.patch text/plain 15.5 KB

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Tom Lane 2000-08-21 15:19:31 Re: [HACKERS] functional index arg matching patch
Previous Message Magnus Hagander 2000-08-20 14:25:03 SSL Patch - again :-)