Martijn van Oosterhout <[email protected]> writes:
> On Thu, Jan 11, 2007 at 07:26:32PM +0100, Rafal Pietrak wrote:
>> So may be "SET CONSTRAINTS .... DEFERRED " should be used somehow
>> differently? I've never had any use for that construct, may be I miss
>> something?
> Only at the beginning of a transaction and it only works on foreign
> keys marked deferrable.
No, you can do it mid-transaction. I think the problem is the second
part: the FK constraint has to be marked deferrable, which is not the
default I believe. Also, you could forget the SET CONSTRAINTS entirely
if you made the constraint INITIALLY DEFERRED ... then it'd always act
as a deferred check.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
