"Boris Makovecki" <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
