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 <[EMAIL PROTECTED]> To: "Boris Makovecki" <[EMAIL PROTECTED]> Cc: pgsql-bugs@postgresql.org Date: Thu, 03 Feb 2005 01:02:01 -0500 Subject: Re: [BUGS] BUG #1455: pg_dumpall fails > "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]) ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
