Re: [GENERAL] Issue installing an extension

2013-02-11 Thread Adrian Klaver

On 02/11/2013 02:33 AM, P. Broennimann wrote:

Hi there

I have installed 9.2.2 on a Debian Squeeze VM.

I am trying to install a third party extension.

1) For the extension I did "make" & "make install".
2) I now see the extension files in
/usr/share/postgresql/9.2/extension/... (files .sql and .control)
3) When I issue CREATE EXTENSION ...  I get an error:

SQL Error: ERROR:  could not open extension control file
"/usr/share/postgresql/9.1/extension/...control": No such file or
directory

-> Seems that CREATE EXTENSION is using ...9.1... in the path. That is
strange as I never installed 9.1


Saying you did not install it is not the same as saying it is not 
installed:) Are you sure there is not a 9.1 instance, maybe something 
that came with the VM?




How can I fix that?

Thx & cheers,
Peter




--
Adrian Klaver
adrian.kla...@gmail.com


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[GENERAL] Issue installing an extension

2013-02-11 Thread P. Broennimann
Hi there

I have installed 9.2.2 on a Debian Squeeze VM.

I am trying to install a third party extension.

1) For the extension I did "make" & "make install".
2) I now see the extension files in /usr/share/postgresql/9.2/extension/...
(files .sql and .control)
3) When I issue CREATE EXTENSION ...  I get an error:

SQL Error: ERROR:  could not open extension control file
"/usr/share/postgresql/9.1/extension/...control": No such file or
directory

-> Seems that CREATE EXTENSION is using ...9.1... in the path. That is
strange as I never installed 9.1

How can I fix that?

Thx & cheers,
Peter