extension installation PB - Mailing list pgsql-novice

From Jean-Yves F. Barbier
Subject extension installation PB
Date
Msg-id 20111106195841.04b25c5b@anubis.defcon1
Whole thread Raw
Responses Re: extension installation PB  (Devrim GÜNDÜZ <devrim@gunduz.org>)
Re: extension installation PB  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
Debian sid - Pg v.9.1.1-3
=========================
Hi list,

I've an old script installing Pg extensions that I modified to fit
from 9.1 paths & file names.
However it throw errors for any extension package, ie:

=# \i /usr/share/postgresql/9.1/extension/adminpack--1.0.sql
psql:/usr/share/postgresql/9.1/extension/adminpack--1.0.sql:12: ERROR:  could not access file "MODULE_PATHNAME": No
suchfile or directory 
psql:/usr/share/postgresql/9.1/extension/adminpack--1.0.sql:17: ERROR:  could not access file "MODULE_PATHNAME": No
suchfile or directory 
psql:/usr/share/postgresql/9.1/extension/adminpack--1.0.sql:22: ERROR:  function pg_catalog.pg_file_rename(text, text,
text)does not exist 
LIGNE 3 : AS 'SELECT pg_catalog.pg_file_rename($1, $2, NULL::pg_catalo...
                     ^
ASTUCE : No function matches the given name and argument types. You might need to add explicit type casts.
psql:/usr/share/postgresql/9.1/extension/adminpack--1.0.sql:27: ERROR:  could not access file "MODULE_PATHNAME": No
suchfile or directory 
psql:/usr/share/postgresql/9.1/extension/adminpack--1.0.sql:32: ERROR:  could not access file "MODULE_PATHNAME": No
suchfile or directory 
psql:/usr/share/postgresql/9.1/extension/adminpack--1.0.sql:40: ERROR:  function "pg_file_read" already exists with
sameargument types 
psql:/usr/share/postgresql/9.1/extension/adminpack--1.0.sql:45: ERROR:  function "pg_file_length" already exists with
sameargument types 
psql:/usr/share/postgresql/9.1/extension/adminpack--1.0.sql:50: ERROR:  function "pg_logfile_rotate" already exists
withsame argument types 

What's wrong?

JY
--
A countryman between two lawyers is like a fish between two cats.
        -- Ben Franklin

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: function error
Next
From: Devrim GÜNDÜZ
Date:
Subject: Re: extension installation PB