Re: Odp: PD: triggered data change violation on relation "tbl_b" - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Odp: PD: triggered data change violation on relation "tbl_b"
Date
Msg-id 11227.999557755@sss.pgh.pa.us
Whole thread Raw
In response to Re: Odp: PD: triggered data change violation on relation "tbl_b"  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Responses Re: Odp: PD: triggered data change violation on relation  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List pgsql-bugs
Stephan Szabo <sszabo@megazone23.bigpanda.com> writes:
> This was a mistake in the interpretation of the spec (modification of
> the same key row referenced by a foreign key constraint in the same
> statement more than once is an error is how we believe the spec meant
> it, but there's a case where they mention transaction and it got
> misinterpreted).  I don't think anyone's permanently fixed it yet, but
> making the check disappear involves commenting out the two blocks that
> throw the message in backend/commands/trigger.c.

Would it be better to just do that until a proper solution is
implemented?  What is the downside of not making any check?

            regards, tom lane

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: Excess disk usage
Next
From: Tom Lane
Date:
Subject: Re: Error in backend/storage/lmgr/proc.c: ProcSleep()