Robert Haas <robertmh...@gmail.com> writes: >> Okay, how we add a "revision" key to the control file and extrevision to >> the pg_extension catalog. Its type can be "TEXT" and is optional for use >> by extensions. > > How would pg_extension.extrevision be kept up to date? AFAICS, the > whole point is that you might swap out the shared libraries without > doing anything at the SQL level.
Well, ALTER EXTENSION UPDATE could be taught to check for control file changes only when there's no upgrade script. I think it already did that for some fields, like require and comment, but it's no longer the case. Still, I would think that it should be possible to update some metadata of the extension without running an SQL upgrade script. Regards, -- Dimitri Fontaine http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers