PostgreSQL Bugs - BUG #2065: Problem with language conversion in pg

Author

BUG #2065: Problem with language conversion in pg_dump

Wim Audenaert

2005-11-23, 7:24 am

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'::pg_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

Tom Lane

2005-11-23, 7:24 am

"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

Tom Lane

2005-11-23, 7:24 am

"Wim Audenaert" <wima85@hotmail.com> writes:
> 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.

Hmm, I see that utf8_to_tcvn() doesn't seem to be there anymore, but
whether that's a bug in itself is for someone else to answer (Tatsuo?).
What I'm wondering about is how a reference to a nonexistent function
OID got into your new database. There is no case in which pg_dump
should reference a function by OID.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

Wim Audenaert

2005-11-23, 8:24 pm

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:
>
>function
>
>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

Wim Audenaert

2005-11-23, 8:24 pm

Hi Tom,

The problem is solved. I have reinstalled Postgres, and now pg_dump works
fine.

Best regards, and thanks for your help.

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 23:45:58 -0500
>
>"Wim Audenaert" <wima85@hotmail.com> writes:
>new
>one.
>
>Hmm, I see that utf8_to_tcvn() doesn't seem to be there anymore, but
>whether that's a bug in itself is for someone else to answer (Tatsuo?).
>What I'm wondering about is how a reference to a nonexistent function
>OID got into your new database. There is no case in which pg_dump
>should reference a function by OID.
>
> regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Bruce Momjian

2005-11-25, 8:24 pm

Tom Lane wrote:
> "Wim Audenaert" <wima85@hotmail.com> writes:
>
> Hmm, I see that utf8_to_tcvn() doesn't seem to be there anymore, but
> whether that's a bug in itself is for someone else to answer (Tatsuo?).
> What I'm wondering about is how a reference to a nonexistent function
> OID got into your new database. There is no case in which pg_dump
> should reference a function by OID.

TCVN is was renamed to the official name PG_WIN1258 in 8.1. This was
part of the general encoding renaming in 8.1.

--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Sponsored Links