Re: foreign key restrictions - Mailing list pgsql-general

From rafal@zorro.isa-geek.com
Subject Re: foreign key restrictions
Date
Msg-id 3767fb86c51e3bf7402503a091134ead.squirrel@localhost
Whole thread Raw
In response to Re: foreign key restrictions  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
> rafal@zorro.isa-geek.com writes:
>>> The reason why is that the SQL spec says so:
>>>
>>> a) If the <referenced table and columns> specifies a
>>> <reference
>>> column list>, then the set of <column name>s contained
>>> in that <reference column list> shall be equal to the
>>> set of <column name>s contained in the <unique column
>>> list> of a unique constraint of the referenced table.
>
>> I must admit, the standard is not very easy reading for me; what exactly
>> does the standarad mean by "<unique column list>":
>> 1. is that a requirement for mathematical properties of that list, or
>
> The point is it says "shall be equal to", not "shall be a superset of".

So its the "meaning nr.2". The "syntax glue" not the actual math of sets.

This is strange, I must say. But no further questions when this is a
"syntax" requirement.

Thenx,

-R


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: foreign key restrictions
Next
From: "Matt Magoffin"
Date:
Subject: Re: Memory use in 8.3 plpgsql with heavy use of xpath()