Bruce Momjian <[email protected]> wrote: > Things like how fresh the materialized view is certainly should > be accessible via SQL and transactional.
Keep in mind that something like "whether the materialized view is fresh enough to be scanned by this connection" may eventually depend on session GUCs and the passage of time in the absence of any database modifications. That's why I believe that checking for scannability should be done through a function, not a check of a system table. -- Kevin Grittner EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
