pgsql: Create syscache entries for pg_extension - Mailing list pgsql-committers

From Michael Paquier
Subject pgsql: Create syscache entries for pg_extension
Date
Msg-id E1sgwwu-000rXp-BQ@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Create syscache entries for pg_extension

Two syscache identifiers are added for extension names and OIDs.

Shared libraries of extensions might want to invalidate or update their
own caches whenever a CREATE, ALTER or DROP EXTENSION command is run for
their extension (in any backend).  Right now this is non-trivial to do
correctly and efficiently, but, if an extension catalog is part of a
syscache, this could simply be done by registering an callback using
CacheRegisterSyscacheCallback for the relevant syscache.

Another case where this is useful is a loaded library where some of its
code paths rely on some objects of the extension to exist; it can be
simpler and more efficient to do an existence check directly on the
extension through the syscache.

Author: Jelte Fennema-Nio
Reviewed-by: Alexander Korotkov, Pavel Stehule
Discussion: https://postgr.es/m/CAGECzQTWm9sex719Hptbq4j56hBGUti7J9OWjeMobQ1ccRok9w@mail.gmail.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/490f869d92e5db38731b85b9be3cffdc65461808

Modified Files
--------------
src/include/catalog/pg_extension.h | 3 +++
1 file changed, 3 insertions(+)


pgsql-committers by date:

Previous
From: Alexander Korotkov
Date:
Subject: Re: pgsql: Add injection-point test for new multixact CV usage
Next
From: Richard Guo
Date:
Subject: pgsql: Small code simplification