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