From: | Kevin Grittner <kgrittn(at)gmail(dot)com> |
---|---|
To: | Melvin Davidson <melvin6925(at)gmail(dot)com> |
Cc: | Jonathan Vanasco <postgres(at)2xlp(dot)com>, "pgsql-general(at)postgresql(dot)org general" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: does postgres log the create/refresh of a materialized view anywhere? |
Date: | 2016-12-14 01:50:43 |
Message-ID: | CACjxUsOFoF23P3rdhotmMcsn=M=f18xOVVtgb4Uh+dNinteiJQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Tue, Dec 13, 2016 at 7:37 PM, Melvin Davidson <melvin6925(at)gmail(dot)com> wrote:
> On Tue, Dec 13, 2016 at 7:36 PM, Kevin Grittner <kgrittn(at)gmail(dot)com> wrote:
>> On Tue, Dec 13, 2016 at 5:57 PM, Jonathan Vanasco <postgres(at)2xlp(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Melvin Davidson | 2016-12-14 02:19:03 | Re: does postgres log the create/refresh of a materialized view anywhere? |
Previous Message | Melvin Davidson | 2016-12-14 01:37:54 | Re: does postgres log the create/refresh of a materialized view anywhere? |