BUG #13663: uuid-ossp in multiple schemas same database

On 10/5/2015 8:47 AM, wjarl@hotmail.com wrote:

I have 1 database named general and 2 schemas crm and erp. When i create
extension "uuid-ossp" i 'need' to specify the schema example erp; create
extension "uuid-ossp" schema erp, however when i try to use it on crm i
can't. if i try to create extension "uuid-ossp" schema crm, it reads
extension "uuid-ossp" already exists.
Any suggestions?

put the extension in the public schema so its available to all schemas
as long as you leave public in the search_path

--
john r pierce, recycling bits in santa cruz

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

I think i got it; will do some testing and get back to you if something goes wrong.

Thanks.