Re: BUG #1455: pg_dumpall fails

Currently I'm using 7.4.0 version. I'll first upgarade to 7.4.7 and then try
to upgarade to 8.0.1,

thanks,
Boris Makovecki
-----Original Message-----
From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Boris Makovecki" <boris(dot)makovecki(at)abak(dot)net>
Cc: pgsql-bugs(at)postgresql(dot)org
Date: Thu, 03 Feb 2005 01:02:01 -0500
Subject: Re: [BUGS] BUG #1455: pg_dumpall fails

> "Boris Makovecki" <boris(dot)makovecki(at)abak(dot)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
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to
> majordomo(at)postgresql(dot)org)