> On Oct 30, 2016, at 4:45 AM, Evan Martin <postgresql2@realityexists.net> wrote:
>
> If I have a query that reads from system tables like pg_class, pg_namespace, pg_attribute, pg_type, etc. and I'd like
tocache the results in my application is there any fast way to detect when any changes have been made to these system
catalogs?I don't need to know exactly what has changed. Some kind of a global "database version" would do, just so I
knowthat I need to invalidate my cache (the database definition is rarely modified in practice).
Maybe create an event trigger that updates a simple table with the last modification time or sends a notification?
https://www.postgresql.org/docs/current/static/sql-createeventtrigger.html
John DeSoi, Ph.D.