Re: surprising trigger/foreign key interaction

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: surprising trigger/foreign key interaction
Дата
Msg-id 14750.1250118267@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: surprising trigger/foreign key interaction  (Alvaro Herrera <alvherre@commandprompt.com>)
Ответы Re: surprising trigger/foreign key interaction  (Stefan Kaltenbrunner <stefan@kaltenbrunner.cc>)
Re: surprising trigger/foreign key interaction  (Alvaro Herrera <alvherre@commandprompt.com>)
Список pgsql-hackers
Alvaro Herrera <alvherre@commandprompt.com> writes:
> However I'm guessing that what actually happens is that heap_update is
> returning HeapTupleSelfUpdated instead, which the code states as
> /* nothing to do */.

Yeah.

> I imagine this is so because of some old fiddling to get semantics just
> right for obscure corner cases, but it feels wrong nevertheless.

I suspect it was reluctance to use the EvalPlanQual semantics (which
are pretty bogus in their own way) for perfectly deterministic
single-transaction cases.
        regards, tom lane


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Error message for FK referencing deferrable unique/PK
Следующее
От: Robert Haas
Дата:
Сообщение: Re: schemapg.h