The following bug has been logged online:

Bug reference: 2065
Logged by: Wim Audenaert
Email address: wima85@hotmail.com
PostgreSQL version: 8.1.0.2
Operating system: Windows XP
Description: Problem with language conversion in pg_dump
Details:

I have a database created with encoding UTF8 while I used SQL_ASCII for the
installation of Postgres 8.1.0.

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
170
39
pg_dump: The command was: SELECT tableoid, oid, adnum,
pg_catalog.pg_get_expr(ad
bin, adrelid) AS adsrc FROM pg_catalog.pg_attrdef WHERE adrelid =
'23268':g_ca
talog.oid

I looked for the function 17039 in the pg_proc table, and this function
doesn't exist. It does exists in an older version of the database (8.0).

I tried to use the encoding parameter in pg_dump, but without success.

What can I do resolve this problem?

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

"Wim Audenaert" <wima85@hotmail.com> 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 majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

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 <tgl@sss.pgh.pa.us>
>To: "Wim Audenaert" <wima85@hotmail.com>
>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" <wima85@hotmail.com> 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 majordomo@postgresql.org so that your
message can get through to the mailing list cleanly