Single server multiple databases - extension

Поиск
Список
Период
Сортировка
От Brian Trudal
Тема Single server multiple databases - extension
Дата
Msg-id 1330995153.59408.YahooMailNeo@web31803.mail.mud.yahoo.com
обсуждение исходный текст
Ответы Re: Single server multiple databases - extension  (Brian Trudal <dbrb2002-sql@yahoo.com>)
Список 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);
                            ^

В списке pgsql-general по дате отправления:

Предыдущее
От: chinnaobi
Дата:
Сообщение: Lost data Folder, but have WAL files--- How to recover the database ?? Windows
Следующее
От: Chris Travers
Дата:
Сообщение: Re: Lost data Folder, but have WAL files--- How to recover the database ?? Windows