Re: More extension issues: ownership and search_path - Mailing list pgsql-hackers

From Tom Lane
Subject Re: More extension issues: ownership and search_path
Date
Msg-id 23382.1297107542@sss.pgh.pa.us
Whole thread Raw
In response to Re: More extension issues: ownership and search_path  (Dimitri Fontaine <dimitri@2ndQuadrant.fr>)
Responses Re: More extension issues: ownership and search_path
List pgsql-hackers
Dimitri Fontaine <dimitri@2ndQuadrant.fr> writes:
> That said, we should do something about ALTER EXTENSION SET SCHEMA and
> the relocatable property.  I'm thinking that an extension stops being
> relocatable as soon as any of its reverse dependencies (all the tree) is
> not relocatable.

If you're worried about that, then it's questionable whether ALTER
EXTENSION SET SCHEMA makes sense at all, ever.  I don't see any reason
to think that an extension is more fragile for this purpose than any
other random SQL dependencies.  Also, an extension being relocatable
doesn't seem to me to guarantee that it can cope with its dependencies
moving around; they're really independent properties.
        regards, tom lane


pgsql-hackers by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: Sync Rep for 2011CF1
Next
From: Robert Haas
Date:
Subject: Re: Sync Rep for 2011CF1