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.
Any help ? db1=# CREATE EXTENSION hstore; ERROR: type "hstore" already exists db1=# DROP EXTENSION hstore; ERROR: extension "hstore" does not exist db1=# create table foo(id hstore); ERROR: type "hstore" is only a shell LINE 1: create table foo(id hstore); ^
