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
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 |