Re: [HACKERS] FK Deferred RI Triggers & SAVEPOINTs --- A"C"ID violation

2007-07-13 Thread Affan Salman
Patch submitted. -- Affan Salman EnterpriseDB Corporation http://www.enterprisedb.com ---(end of broadcast)--- TIP 6: explain analyze is your friend

[HACKERS] FK Deferred RI Triggers & SAVEPOINTs --- A"C"ID violation

2007-07-12 Thread Affan Salman
I think I have stumbled across a bug here; While skipping queuing of an RI trigger for a non-FK UPDATE, the "non-optimizable exception" check (see below) in trigger.c @ AfterTriggerSaveEvent() fails to handle SAVEPOINTs correctly and can jovially leave inconsistent data behind at transaction com