|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|
|Views:||Raw Message | Whole Thread | Download mbox | Resend email|
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:
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.
http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support
|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|