On Tue, Dec 13, 2016 at 7:37 PM, Melvin Davidson <melvin6925@xxxxxxxxx> wrote: > On Tue, Dec 13, 2016 at 7:36 PM, Kevin Grittner <kgrittn@xxxxxxxxx> wrote: >> On Tue, Dec 13, 2016 at 5:57 PM, Jonathan Vanasco <postgres@xxxxxxxx> 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@xxxxxxxxxxxxxx > 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
