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

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

Thanks.

> Subject: Re: [BUGS] BUG #13663: uuid-ossp in multiple schemas same database
> To: wjarl(at)hotmail(dot)com; pgsql-bugs(at)postgresql(dot)org
> From: pierce(at)hogranch(dot)com
> Date: Mon, 5 Oct 2015 09:49:18 -0700
>
> On 10/5/2015 8:47 AM, wjarl(at)hotmail(dot)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
>