Re: Materialized views WIP patch

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: Materialized views WIP patch
Дата
Msg-id 51253F5E.7000703@gmx.net
обсуждение исходный текст
Ответ на Re: Materialized views WIP patch  (Kevin Grittner <kgrittn@ymail.com>)
Ответы Re: Materialized views WIP patch  (Kevin Grittner <kgrittn@ymail.com>)
Re: Materialized views WIP patch  (Greg Stark <stark@mit.edu>)
Список pgsql-hackers
On 2/20/13 2:30 PM, Kevin Grittner wrote:
>> Are there TRUNCATE triggers on materialized views?
> No.  Nor SELECT, INSERT, UPDATE, or DELETE triggers.  You can't
> create a trigger of any type on a materialized view.  I don't think
> that would interfere with event triggers, though.

More generally, I would consider the invalidation of a materialized view
a DDL command, whereas truncating a table is a DML command.  This has
various implications with triggers, logging, permissions.  I think it's
not good to mix those two.

Also note that un-invalidating==refreshing a materialized view is
already a DDL command.




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

Предыдущее
От: Phil Sorber
Дата:
Сообщение: Re: [PATCH] Add PQconninfoParseParams and PQconninfodefaultsMerge to libpq
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: PATCH: Split stats file per database WAS: autovacuum stress-testing our system