Re: [HACKERS] transition table behavior with inheritance appearsbroken (was: Declarative partitioning - another take)

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: [HACKERS] transition table behavior with inheritance appearsbroken (was: Declarative partitioning - another take)
Дата
Msg-id 20170509215749.thbttlftkrhzie4v@alvherre.pgsql
обсуждение исходный текст
Ответ на Re: [HACKERS] transition table behavior with inheritance appearsbroken (was: Declarative partitioning - another take)  (Thomas Munro <thomas.munro@enterprisedb.com>)
Ответы Re: [HACKERS] transition table behavior with inheritance appearsbroken (was: Declarative partitioning - another take)  (Thomas Munro <thomas.munro@enterprisedb.com>)
Список pgsql-hackers
Thomas Munro wrote:

> Recall that transition tables can be specified for statement-level
> triggers AND row-level triggers.  If you specify them for row-level
> triggers, then they can see all rows changed so far each time they
> fire.

Uhmm ... why do we do this?  It seems like a great way to cause much
confusion.  Shouldn't we see the transition table containing the whole
set for statement-level triggers only, and give row-level triggers just
the individual affected row each time?

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services



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

Предыдущее
От: Thomas Munro
Дата:
Сообщение: Re: [HACKERS] transition table behavior with inheritance appearsbroken (was: Declarative partitioning - another take)
Следующее
От: Andrew Dunstan
Дата:
Сообщение: Re: [HACKERS] CTE inlining