Single server multiple databases - extension

From: Brian Trudal <dbrb2002-sql(at)yahoo(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Single server multiple databases - extension
Date: 2012-03-06 00:52:33
Message-ID: 1330995153.59408.YahooMailNeo@web31803.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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);
                            ^

Responses

Browse pgsql-general by date

  From Date Subject
Next Message chinnaobi 2012-03-06 02:38:44 Lost data Folder, but have WAL files--- How to recover the database ?? Windows
Previous Message Merlin Moncure 2012-03-06 00:01:31 Re: Memory usage and configuration settings