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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Odp: PD: triggered data change violation on relation "tbl_b"
Дата
Msg-id 11227.999557755@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Odp: PD: triggered data change violation on relation "tbl_b"  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Ответы Re: Odp: PD: triggered data change violation on relation  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Excess disk usage
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Error in backend/storage/lmgr/proc.c: ProcSleep()