Thread: More FK constraint stuff

More FK constraint stuff

From
Stephan Szabo
Date:
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@bigpanda.com

Attachment

Re: More FK constraint stuff

From
Bruce Momjian
Date:
Applied.  Thanks.


>
> 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@bigpanda.com
Content-Description:

[ Attachment, skipping... ]


--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026