Re: [GENERAL] does postgres log the create/refresh of a materializedview anywhere? - Mailing list pgsql-general

From Michael Paquier
Subject Re: [GENERAL] does postgres log the create/refresh of a materializedview anywhere?
Date
Msg-id CAB7nPqSWgUFBBfg08qEF0vNzqpq8kszwvBzXeSJbUEigpV7x3g@mail.gmail.com
Whole thread Raw
In response to Re: [GENERAL] does postgres log the create/refresh of a materializedview anywhere?  (Melvin Davidson <melvin6925@gmail.com>)
List 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 by date:

Previous
From: Michael Paquier
Date:
Subject: Re: [GENERAL] vacuum freeze in 96
Next
From: Thomas Kellerer
Date:
Subject: Re: [GENERAL] pg_dump and quoted identifiers