That solved the issue. Apart from hstore, I needed to drop ghstore as well.
Thanks again
From: Tom Lane
To: Brian Trudal
Cc: Bartosz Dmytrak ; "pgsql-general@postgresql.org"
Sent: Tuesday, March 6, 2012 4:09 PM
Subject: Re: [GENERAL] Sin
Brian Trudal writes:
> Thanks for getting back to me. Still no luck; and I tried all possibilities..
> For example, when I tried on new DB:
> db1=# CREATE EXTENSION hstore
> SCHEMA public
> VERSION "1.0";
> ERROR: type "hstore" already exists
> db1=# create table foo(id hstore);
> ERROR: t
From: Bartosz Dmytrak
To: Brian Trudal
Cc: "pgsql-general@postgresql.org"
Sent: Tuesday, March 6, 2012 1:02 PM
Subject: Re: [GENERAL] Single server multiple databases - extension
Hi,
there shouldn't be any problem in installing extensions to multiple databases
in the sa
Hi,
there shouldn't be any problem in installing extensions to multiple
databases in the same server. Extensions are per database:
http://www.postgresql.org/docs/9.1/static/sql-createextension.html
You can use pgAdmin, or try this syntax:
CREATE EXTENSION hstore
SCHEMA public
VERSION "1.0";
Any one know how to install extensions to multiple databases in the same server
?
Thanks in advance
Brian
From: Brian Trudal
To: "pgsql-general@postgresql.org"
Sent: Monday, March 5, 2012 4:52 PM
Subject: Single server multiple databases - extension
Hi
I
Hi
I have 2 databases running in a single server; and I installed extension
'hstore' to one database and it works fine. When I tried to use the same
extension in another database, it gives an error saying 'extension does not
exist'; nor it allow to install as it complains about its existence.