Re: [GENERAL] Multiple Schema and extensions

2012-09-26 Thread Albe Laurenz
Alan Nilsson wrote: > Is it the case that extensions can be added to only one schema? If so, what is the recommended > practice for accessing a function from an extension in multiple schemas? Yes, a (relocatable) extension can belong to only one schema. There are two ways to access the functions:

[GENERAL] Multiple Schema and extensions

2012-09-25 Thread Alan Nilsson
Is it the case that extensions can be added to only one schema? If so, what is the recommended practice for accessing a function 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* t