Re: BUG #2065: Problem with language conversion in pg_dump

From: "Wim Audenaert" <wima85(at)hotmail(dot)com>
To: tgl(at)sss(dot)pgh(dot)pa(dot)us
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #2065: Problem with language conversion in pg_dump
Date: 2005-11-23 04:39:02
Message-ID: BAY109-F6862ECA18DA5F6F2B884DD0550@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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(at)sss(dot)pgh(dot)pa(dot)us>
>To: "Wim Audenaert" <wima85(at)hotmail(dot)com>
>CC: pgsql-bugs(at)postgresql(dot)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(at)hotmail(dot)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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2005-11-23 04:45:58 Re: BUG #2065: Problem with language conversion in pg_dump
Previous Message Vladimir 2005-11-23 04:29:25 BUG #2068: Error compiled OS Solaris