Re: [GENERAL] does postgres log the create/refresh of a materializedview anywhere?

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: [GENERAL] does postgres log the create/refresh of a materializedview anywhere?
Дата
Msg-id CAB7nPqSWgUFBBfg08qEF0vNzqpq8kszwvBzXeSJbUEigpV7x3g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [GENERAL] does postgres log the create/refresh of a materializedview anywhere?  (Melvin Davidson <melvin6925@gmail.com>)
Список pgsql-general
On Wed, Dec 14, 2016 at 11:19 AM, Melvin Davidson <melvin6925@gmail.com> wrote:
> Originally, all I wanted was a column to record the creation date/time of an object. One reason it was debunked was
thatit would lead 
> to a request for an additional column to record changes in objects. I maintain that both can be done, but others
disagree,

Event triggers could be used to track the creation or drop timestamp
of objects. Even if it is not supported for REFRESH, it may make sense
to support it in the firing matrix.
--
Michael


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

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: [GENERAL] vacuum freeze in 96
Следующее
От: Thomas Kellerer
Дата:
Сообщение: Re: [GENERAL] pg_dump and quoted identifiers