extension installation PB
От | Jean-Yves F. Barbier |
---|---|
Тема | extension installation PB |
Дата | |
Msg-id | 20111106195841.04b25c5b@anubis.defcon1 обсуждение исходный текст |
Ответы |
Re: extension installation PB
Re: extension installation PB |
Список | 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 по дате отправления: