pg_dump support for Extension, patch version 24

From: Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
To: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: pg_dump support for Extension, patch version 24
Date: 2011-01-13 20:57:22
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers


Please find an updated (merged) version 24 of the extension patch set,
simplified to follow on Tom's comment about dependency tracking when
doing ALTER EXTENSION SET SCHEMA. We now follow only one level of
dependencies, and that just works (thanks Tom).

On the same idea, I also removed the pg_extension_objects() function and
implemented \dx+ using Alvaro's recent addition, pg_describe_object().
You can see this in the doc part of the incremental UPGRADE patch:

-SELECT 'alter ' || objdesc || ' set extension pair;'
- FROM pg_extension_objects('pair');
+SELECT 'alter ' || pg_describe_object(classid, objid, 0) || ' set extension pair;'
+ FROM pg_depend
+ WHERE refclassid = 'pg_extension'::regclass
+ AND refobjid = (SELECT oid FROM pg_extension WHERE extname = 'pair')

If some of you here had been working on the previous version of the
patch, the incremental diff is available on the git repository:;a=commitdiff;h=bac353f1040465b7bd95afbca2fd699f3bd699ff

Hey, look at that, an incremental patch that (again) removes code:
9 files changed, 53 insertions(+), 161 deletions(-)

The documentation is updated online too:

You will find 3 attachments related to the main extension's patch, the
all-inclusive patch, and the contrib and "core" separated out: Robert
said it could ease reviewing and git offers an easy way to do that
splitting. Also, please note that the ALTER EXTENSION UPGRADE patch is
incremental, you need to first apply the extension's patch.

Should an all-inclusive (Extension + Upgrade) patch suit some reviewer
here, just ask and I'll provide it, or you could git clone my repository.

Dimitri Fontaine PostgreSQL : Expertise, Formation et Support

Attachment Content-Type Size
extension.v24.patch.gz application/octet-stream 57.8 KB
extension.v24.contrib.patch.gz application/octet-stream 14.8 KB
extension.v24.src-doc.patch.gz application/octet-stream 43.1 KB
upgrade_extension.v2.patch.gz application/octet-stream 17.9 KB

Browse pgsql-hackers by date

  From Date Subject
Next Message Kevin Grittner 2011-01-13 21:05:10 SSI patch version 11
Previous Message Josh Berkus 2011-01-13 20:57:03 Re: Allowing multiple concurrent base backups