Re: BUG #1455: pg_dumpall fails - Mailing list pgsql-bugs

"Boris Makovecki" <boris.makovecki@abak.net> writes:
> I'm trying to migrate postgre DB from 7.4 to 8.0. When I start pg_dumpall
> (8.0) and connect it to 7.4 it fails with error:

> pg_dump: SQL command failed
> pg_dump: Error message from server: ERROR:  cannot cast type "unknown" to
> text
> pg_dump: The command was: SELECT proretset, prosrc, probin, null::text as
> proargnames, provolatile, proisstrict, prosecdef, (SELECT lanname FROM
> pg_catalog.pg_language WHERE oid = prolang) as lanname FROM
> pg_catalog.pg_proc WHERE oid = '17926077'::pg_catalog.oid

Works fine for me, using a 7.4.7 server.  Possibly you are hitting some
bug in an earlier 7.4.* release?  (I don't see anything promising
looking in the CVS logs, though.)  What *exactly* is the server version?

            regards, tom lane