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
ension_versions
WHERE name = 'hstore';
-[ RECORD 1 ]-
name | hstore
version | 1.0
installed | t
superuser | t
relocatable | t
schema |
requires |
comment | data type for storing sets of (key, value) pairs
any other hints ?
________
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 - exten
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.
