Re: [HACKERS] Foreign key referential action timing

2004-10-21 Thread Tom Lane
Stephan Szabo <[EMAIL PROTECTED]> writes: > While not exactly what the spec invisions, I believe we can come > closer to the correct behavior by treating all of the referential actions > as non-deferrable while allowing deferment of NO ACTION and the check > itself. Since no one seems to hav

[HACKERS] Foreign key referential action timing

2004-10-05 Thread Stephan Szabo
As a side effect of fixing timing issues with the new trigger timing, Tom and I noticed that some foreign key actions were broken (especially with deferred constraints) and as part of looking at that we believe that we had made the wrong decision as to when the actions were meant to fire i