Re: delta relations in AFTER triggers

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: delta relations in AFTER triggers
Дата
Msg-id 1402850026.55960.YahooMailNeo@web122303.mail.ne1.yahoo.com
обсуждение исходный текст
Ответ на Re: delta relations in AFTER triggers  (David Fetter <david@fetter.org>)
Список pgsql-hackers
David Fetter <david@fetter.org> wrote:

> Any chance we might be able to surface the old version for the
> case of UPDATE ... RETURNING?

Not as part of this patch.

Of course, once delta relations are available, who knows what
people might do with them.  I have a hard time imagining exactly
how you would expose what you're talking about, but a column to
distinguish before and after images might work.  Incremental
maintenance of materialized views will require that in the form of
a count column with -1 for deleted and +1 for inserted, so there
might be some common ground when we get to that.

--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



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

Предыдущее
От: David Fetter
Дата:
Сообщение: Re: delta relations in AFTER triggers
Следующее
От: "David E. Wheeler"
Дата:
Сообщение: Re: make check For Extensions