On Jul 22, 2009, at 11:46 AM, Dimitri Fontaine wrote:

Here are from memory the problems we don't have a solution for yet:
- how to give user the ability to install the extension's objects in another schema than the pg_extension default one

Was that not a part of your original proposal, or the ensuing discussion? Hrm, perhaps not. So I suggest that we take your proposed syntax:

create extension foo ...

And just allow it to take a schema-qualified argument like any other SQL command:

create extension myschema.foo ...

- how to provide extension author a way to have major PG version dependant code without having to implement and maintain a specific function in their install.sql file

For a lot of extensions this may not be necessary. So I don't think I'd hold up an initial implementation waiting for this to be figured out. My $0.02.

Best,

David

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Reply via email to