Zeugswetter Andreas SB <ZeugswetterA@wien.spardat.at> writes:
> FOREIGN KEY INSERT & UPDATE/DELETE in transaction "change violation"
>>
>> A well known issue, and I've asked multiple times how exactly
>> we want to define the behaviour for deferred constraints. Do
>> foreign keys reference just to a key value and are happy with
>> it's existance, or do they refer to a particular row?
> Sorry, to answer late. I didn't know this needed clarification.
> The answer is simple, foreign keys only reference a key value,
> not a particular row.
Cite chapter and verse in the spec, please?
regards, tom lane