Обсуждение: Dump error

Поиск
Список
Период
Сортировка

Dump error

От
ivan
Дата:
pg_dump: handler procedure for procedural language "plpgsql" not found
pg_dumpall: pg_dump failed on database "db", exiting

why ?

i create this language by script createlang as superuser for this database
so, ?

:)



Re: Dump error

От
Jochem van Dieten
Дата:
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





Re: Dump error

От
Tom Lane
Дата:
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