Re: [BUGS] Combination of Triggers and self-FKs produces inconsistent data

2009-01-29 Thread Gregory Stark
Tom Lane writes: > It doesn't say that, because it isn't true. What is true is that if you > make a trigger that prevents updates from happening, it breaks RI > updates as well as directly-user-initiated updates. Can we detect that this happened and throw an error? I suspect not, though, sinc

Re: [BUGS] Combination of Triggers and self-FKs produces inconsistent data

2009-01-29 Thread Josh Berkus
Tom, You can't have your cake and eat it too, Josh. If we make the RI mechanism operate at a level underneath triggers, then we'll lose all sorts of useful capability that people are depending on. A couple of examples: * the ability to log table changes caused by RI cascades * the ability to