Dump error

ivan wrote:

pg_dump: handler procedure for procedural language "plpgsql" not found
pg_dumpall: pg_dump failed on database "db", exiting

why ?

Perhaps the pg_dump bug with procedural language handlers which
have been created in the pg_catalog schema:
http://archives.postgresql.org/pgsql-general/2003-01/msg00006.php

Jochem

Jochem van Dieten <jochemd@oli.tudelft.nl> writes:

Perhaps the pg_dump bug with procedural language handlers which
have been created in the pg_catalog schema:
http://archives.postgresql.org/pgsql-general/2003-01/msg00006.php

Since no better solution has emerged since January, I've applied a patch
along the lines we discussed then (make pg_dump simply ignore languages
for which it doesn't find the handler in finfo[]).

regards, tom lane