>> So I'm going to prepare the next version of the patch with this design: >> >> - in catalog extension scripts for inline extension >> >> pg_extension_script(extoid, oldversion, version, script) >> >> oldversion is null when create extension is used >> unless when using the create extension from 'unpackaged' form > > Would you keep all the migration scripts used over time to upgrade from one > version to another?
yes, that is the idea. You then can play all the stack of SQL needed to go from version "foo" to version "bar" (we don't care about version format, here again). >> - same as we have -t, add -e --extension to pg_dump so that you can >> choose to dump only a given extension > > Also --exclude-extension? It might be the default. We need something to dump the content of pg_catalog.pg_extension_script (or whatever table is going to contain SQL code), per extension or all. -- Cédric Villemain +33 (0)6 20 30 22 52 http://2ndQuadrant.fr/ PostgreSQL: Support 24x7 - Développement, Expertise et Formation -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers