Re: search_path vs extensions - Mailing list pgsql-hackers

From Tom Lane
Subject Re: search_path vs extensions
Date
Msg-id 25641.1243630172@sss.pgh.pa.us
Whole thread Raw
In response to Re: search_path vs extensions  (Greg Stark <stark@enterprisedb.com>)
Responses Re: search_path vs extensions  (Andrew Dunstan <andrew@dunslane.net>)
Re: search_path vs extensions  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
Greg Stark <stark@enterprisedb.com> writes:
> I'm actually not sure if we should allow extensions to be installed
> into separate schemas.

It's starting to seem that best practice is to install "public"
functions/etc into a common schema and "private" objects into an
extension-specific schema.  The main problem with that from an extension
author's point of view is the need to explicitly qualify all references
to private objects, since they won't be in the search path.  Which is
tedious, but doable.

Another issue is that doing that pretty much hard-wires what the
extension's private schema name is.  Dunno how much we care, though.

You could certainly do this without any new search-path-related
features, but I wonder whether the system could provide any extra
support for it.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Clean shutdown and warm standby
Next
From: Andrew Dunstan
Date:
Subject: Re: search_path vs extensions