Skip site navigation (1) Skip section navigation (2)

BUG #6199: Can't install datatype hstore

From: "Hadmut" <hadmut(at)danisch(dot)de>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #6199: Can't install datatype hstore
Date: 2011-09-06 11:55:09
Message-ID: 201109061155.p86Bt9ja006800@wwwmaster.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      6199
Logged by:          Hadmut
Email address:      hadmut(at)danisch(dot)de
PostgreSQL version: 9.1 rc1
Operating system:   Ubuntu Oneiric
Description:        Can't install datatype hstore
Details: 

Hi,

I'd like to run a database application which requires datatype hstore. 

But when trying something like

psql -f /usr/share/postgresql/9.1/extension/hstore--1.0.sql


I get error messages like 

psql:/usr/share/postgresql/9.1/extension/hstore--1.0.sql:8: NOTICE:  return
type hstore is only a shell
psql:/usr/share/postgresql/9.1/extension/hstore--1.0.sql:8: ERROR:  could
not access file "MODULE_PATHNAME": Datei oder Verzeichnis nicht gefunden
psql:/usr/share/postgresql/9.1/extension/hstore--1.0.sql:13: NOTICE: 
argument type hstore is only a shell
psql:/usr/share/postgresql/9.1/extension/hstore--1.0.sql:13: ERROR:  could
not access file "MODULE_PATHNAME": Datei oder Verzeichnis nicht gefunden
psql:/usr/share/postgresql/9.1/extension/hstore--1.0.sql:18: NOTICE:  return
type hstore is only a shell
psql:/usr/share/postgresql/9.1/extension/hstore--1.0.sql:18: ERROR:  could
not access file "MODULE_PATHNAME": Datei oder Verzeichnis nicht gefunden
psql:/usr/share/postgresql/9.1/extension/hstore--1.0.sql:23: NOTICE: 
argument type hstore is only a shell
psql:/usr/share/postgresql/9.1/extension/hstore--1.0.sql:23: ERROR:  could
not access file "MODULE_PATHNAME": Datei oder Verzeichnis nicht gefunden
psql:/usr/share/postgresql/9.1/extension/hstore--1.0.sql:32: ERROR: 
function hstore_in(cstring) does not exist
psql:/usr/share/postgresql/9.1/extension/hstore--1.0.sql:37: NOTICE: 
argument type hstore is only a shell
 
...


regards

Responses

pgsql-bugs by date

Next:From: Bruce MomjianDate: 2011-09-06 14:04:42
Subject: Re: BUG #5932: CLUSTER doesn't update n_dead_tup
Previous:From: Andy LesterDate: 2011-09-06 04:09:02
Subject: Re: BUG #5932: CLUSTER doesn't update n_dead_tup

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group