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

From Kevin Grittner
Subject Re: [GENERAL] does postgres log the create/refresh of a materializedview anywhere?
Date
Msg-id CACjxUsOFoF23P3rdhotmMcsn=M=f18xOVVtgb4Uh+dNinteiJQ@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>)
Responses Re: [GENERAL] does postgres log the create/refresh of a materializedview anywhere?
List pgsql-general
On Tue, Dec 13, 2016 at 7:37 PM, Melvin Davidson <melvin6925@gmail.com> wrote:
> On Tue, Dec 13, 2016 at 7:36 PM, Kevin Grittner <kgrittn@gmail.com> wrote:
>> On Tue, Dec 13, 2016 at 5:57 PM, Jonathan Vanasco <postgres@2xlp.com> wrote:
>>
>>> Is there a way to find out when a materialized view was
>>> created/refreshed?
>>
>>> I can log this manually in postgresql if needed, but was hoping
>>> there was some "timestamp" on the view in a system table.
>>
>> This is not currently tracked in the system catalogs.

> This goes back to a discussion of my request to add relcreated
> column to pg_class.
> https://www.postgresql.org/message-id/CANu8FiyiRPGZ+gB=1JAYryX3HXCuQnFLSFgdzfXSvLMJ-jTc5w@mail.gmail.com
> Apparently the naysayers do not feel it is worthwhile.

Do you see relcreated as being something to set anew whenever the
data contents of a materialized view change due to the REFRESH
command?  I wouldn't have thought so, but I guess the problem with
that proposal is that everyone has a different idea of what the
semantics of the column would be.  Suggesting that field as the
solution here seems to reinforce that perception, anyway.

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


pgsql-general by date:

Previous
From: Melvin Davidson
Date:
Subject: Re: [GENERAL] does postgres log the create/refresh of a materializedview anywhere?
Next
From: Melvin Davidson
Date:
Subject: Re: [GENERAL] does postgres log the create/refresh of a materializedview anywhere?