Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group