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