I think i got it=3B will do some testing and get back to you if something g=
oes wrong.
Thanks.
> Subject: Re: [BUGS] BUG #13663: uuid-ossp in multiple schemas same databa=
se
> To: wjarl@hotmail.com=3B pgsql-bugs@postgresql.org
> From: pierce@hogranch.com
> Date: Mon=2C 5 Oct 2015 09:49:18 -0700
>=20
> On 10/5/2015 8:47 AM=2C wjarl@hotmail.com wrote:
> > I have 1 database named general and 2 schemas crm and erp. When i creat=
e
> > extension "uuid-ossp" i 'need' to specify the schema example erp=3B cre=
ate
> > extension "uuid-ossp" schema erp=2C however when i try to use it on crm=
i
> > can't. if i try to create extension "uuid-ossp" schema crm=2C it reads
> > extension "uuid-ossp" already exists.
> > Any suggestions?
>=20
>=20
> put the extension in the public schema so its available to all schemas=20
> as long as you leave public in the search_path
>=20
>=20
>=20
> --=20
> john r pierce=2C recycling bits in santa cruz
>=20
=