From: | Jeff Eckermann <jeckermann(at)verio(dot)net> |
---|---|
To: | "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org> |
Subject: | pg_dump failure: "handler procedure for language plpgsql not foun d" |
Date: | 2001-04-23 21:24:20 |
Message-ID: | 08CD1781F85AD4118E0800A0C9B8580B094A43@NEZU |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I am attempting to do a pg_dump, preparing to upgrade to 7.1.
I have attempted a pg_dumpall, as well as pg_dump for various individual
databases, and each fails with the message "dumpProcLangs(): handler
procedure for language plpgsql not found"
Everything appears to be in place (see below), and I am stumped. The only
likely cause seems to be some new problem introduced when I recently
upgraded my OS (from FreeBSD 4.0 to 4.3-RC), and upgraded pgsql at the same
time (7.00 to 7.03: bugs were biting). Everything else seems to be
working...
I would be very grateful for any suggestions as to how to fix this.
TIA
template1=# select * from pg_proc where proname like 'plpg%';
proname | proowner | prolang | proisinh | proistrusted |
proiscachable | pronargs | proretset | prorettype | proargtypes |
probyte_pct | properbyte_cpu | propercall_cpu | prooutin_ratio | prosrc |
probin
----------------------+----------+---------+----------+--------------+------
---------+----------+-----------+------------+-------------+-------------+--
--------------+----------------+----------------+--------+------------------
---------------
plpgsql_call_handler | 71 | 13 | f | t | f
| 0 | f | 0 | | 100 |
0 | 0 | 100 | - |
/usr/local/pgsql/lib/plpgsql.so
(1 row)
template1=# \! ls /usr/local/pgsql/lib/plpgsql.so
/usr/local/pgsql/lib/plpgsql.so
template1=#
From | Date | Subject | |
---|---|---|---|
Next Message | Fran Fabrizio | 2001-04-23 21:29:35 | Re: installing DBD::Pg without installing postgres |
Previous Message | Antonio Gennarini - Geotronix | 2001-04-23 20:47:15 | Generating reports with LaTex from PgSQL db? |