Re: Extensions, this time with a patch

On Tue, Oct 12, 2010 at 08:57:09PM +0200, Dimitri Fontaine wrote:
> Hi,
>
> Please find attached a WIP patch for extension's pg_dump support in
> PostgreSQL, following design decisions that we've outlined earlier at
> this year's and last year's PGCon developer meetings.
>
> What's in the patch?
>
> An extension is a new SQL object with a catalog and two commands to
> manage them (reserved to superuser):
>
> CREATE EXTENSION <extension> ;
> DROP EXTENSION [IF EXISTS] <extension> [ RESTRICT | CASCADE ];

Kudos!

> - User Documentation. Where in the manual do I write it?

Parts belong in Server Administration, others in Server Programming.

> - Extension Upgrading
>
> Should this be done by means of 'create extension' or some other
> command, like 'alter extension foo upgrade'? The command would
> run the SQL script again, which would be responsible for any
> steps the extension author might find necessary to run.

As people will want to up- or downgrade extensions to a particular
version, this should probably be something more like ALTER EXTENSION
... SET VERSION [version number | LATEST | PREVIOUS ]... or something
like that.

Cheers,
David.
--
David Fetter <david(at)fetter(dot)org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david(dot)fetter(at)gmail(dot)com
iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate