Multiple Schema and extensions - Mailing list pgsql-general

From Alan Nilsson
Subject Multiple Schema and extensions
Date
Msg-id EFCC5DA0-F2E6-48B4-8727-3154A3F1A007@apple.com
Whole thread Raw
Responses Re: Multiple Schema and extensions  ("Albe Laurenz" <laurenz.albe@wien.gv.at>)
List pgsql-general
Is it the case that extensions can be added to only one schema?  If so, what is the recommended practice for accessing
afunction from an extension in multiple schemas? 

Is it *ok* to load the extension in the pg_catalog schema so functions can be accessed by unqualified names?  Is it
*better*to have a separate schema for functions and use qualified names to access?  What is the general accepted
practice?

As a side note:
ALTER EXTENSION foo ADD SCHEMA bar
What the heck does this do?  AFICS, it has no effect on the visibility of an extension function in the *added* schema.

thanks
alan



pgsql-general by date:

Previous
From: Alban Hertroys
Date:
Subject: Re: In one of negative test row-level trigger results into loop
Next
From: Amit Kapila
Date:
Subject: Re: In one of negative test row-level trigger results into loop