extension installation PB

From: "Jean-Yves F(dot) Barbier" <12ukwn(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: extension installation PB
Date: 2011-11-06 18:58:41
Message-ID: 20111106195841.04b25c5b@anubis.defcon1
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 such file or directory
psql:/usr/share/postgresql/9.1/extension/adminpack--1.0.sql:17: ERROR: could not access file "MODULE_PATHNAME": No such file 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 such file or directory
psql:/usr/share/postgresql/9.1/extension/adminpack--1.0.sql:32: ERROR: could not access file "MODULE_PATHNAME": No such file or directory
psql:/usr/share/postgresql/9.1/extension/adminpack--1.0.sql:40: ERROR: function "pg_file_read" already exists with same argument types
psql:/usr/share/postgresql/9.1/extension/adminpack--1.0.sql:45: ERROR: function "pg_file_length" already exists with same argument types
psql:/usr/share/postgresql/9.1/extension/adminpack--1.0.sql:50: ERROR: function "pg_logfile_rotate" already exists with same argument types

What's wrong?

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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Devrim GÜNDÜZ 2011-11-06 19:04:52 Re: extension installation PB
Previous Message Tom Lane 2011-11-05 23:31:13 Re: function error