Hello Tom,
It's failing on the pg_proc table. This table is not included in the
standard dump.
When I create a new database, this function (oid 17039 and used for utf8
translation) is not defined in the pg_proc table. I tried to create a new
database. The pg_proc table contains several functions, but not this one.
Best regards,
Wim
From: Tom Lane <[EMAIL PROTECTED]>
To: "Wim Audenaert" <[EMAIL PROTECTED]>
CC: pgsql-bugs@postgresql.org
Subject: Re: [BUGS] BUG #2065: Problem with language conversion in pg_dump
Date: Tue, 22 Nov 2005 22:36:56 -0500
"Wim Audenaert" <[EMAIL PROTECTED]> writes:
> When I try to do a pg_dump of my database, I get the following error
> message:
> pg_dump: SQL command failed
> pg_dump: Error message from server: ERROR: cache lookup failed for
function
> 17039
I'm not sure how you managed that, but I'm sure that it's entirely
unrelated to the database's encoding.
Do you still have the dump file that you used to move from 8.0 to 8.1?
If so, what does it show as the declaration for this table?
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
