Re: Extension Facility - Mailing list pgsql-hackers

From David E. Wheeler
Subject Re: Extension Facility
Date
Msg-id 1A8488FF-11F2-4381-8577-ECC3B6A2EA94@kineticode.com
Whole thread Raw
In response to Extension Facility  (Dimitri Fontaine <dfontaine@hi-media.com>)
Responses Re: Extension Facility  (Dimitri Fontaine <dfontaine@hi-media.com>)
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: "David E. Wheeler"
Date:
Subject: Re: extension facility (was: revised hstore patch)
Next
From: Nikhil Sontakke
Date:
Subject: Re: [PATCH] DefaultACLs