create extension failed

Поиск
Список
Период
Сортировка
Искать
От
alp@sfedu.ru
Тема
create extension failed
Дата
Msg-id
20110922004039.13341j0dxc90tjgn@webmail.rsu.ru
Список
Дерево обсуждения
create extension failed alp@sfedu.ru
Re: create extension failed Craig Ringer <ringerc@ringerc.id.au>
Hello.
I have one test database, which was upgraded from 8.4 to 9.0. Now I've  
upgraded it to 9.1. I'm trying to create extension for hstore.

db=# CREATE EXTENSION hstore WITH SCHEMA public FROM unpackaged;
ERROR:  function hstore_recv(internal) does not exist

I suppose, that hstore_recv was added in 9.0, but I didn't update  
hstore extension after upgrading from 8.4 to 9.0. Is this assumption  
correct? How am I supposed to deal with this situation?

Finally, I was able to create extension after the following:
sed -e 's|MODULE_PATHNAME|$libdir/hstore|' <  
/usr/local/share/postgresql/extension/hstore--1.0.sql | su pgsql -c  
'psql -d db '
db=# CREATE EXTENSION hstore WITH SCHEMA public FROM unpackaged;

I'm not sure if it was a right thing...

-- 
С уважением,
Александр Пыхалов,
системный администратор ЮГИНФО ЮФУ
В списке pgsql-general по дате отправления
От: Szymon Guz
Дата:
Сообщение: Re: Random multiple times
От: Mike Christensen
Дата:
FAQ