Re: Odp: PD: triggered data change violation on relation "tbl_b"

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Odp: PD: triggered data change violation on relation "tbl_b"
Date: 2001-09-03 22:55:55
Message-ID: 11227.999557755@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2001-09-03 23:56:08 Re: Error in backend/storage/lmgr/proc.c: ProcSleep()
Previous Message Tom Lane 2001-09-03 22:09:50 Re: Excess disk usage