Обсуждение: BUG #13663: uuid-ossp in multiple schemas same database

The following bug has been logged on the website:

Bug reference:      13663
Logged by:          Jarl Walker
Email address:      wjarl@hotmail.com
PostgreSQL version: 9.3.4
Operating system:   Centos 6.4
Description:

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?

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

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
                           =