Re: cache lookup failed for function 0 - Mailing list pgsql-general

From Tom Lane
Subject Re: cache lookup failed for function 0
Date
Msg-id 1717206.1696170753@sss.pgh.pa.us
Whole thread Raw
In response to Re: cache lookup failed for function 0  (pf@pfortin.com)
List pgsql-general
pf@pfortin.com writes:
> I see the string "SET client_encoding = 'WIN1252';" in the dump -- some
> files come from a remote colleague; but this has never been an issue
> before...

Hah!  If I create the test database with encoding WIN1252 then your
test fails as described.  It *should* be complaining that it doesn't
know how to convert from ISO-8859-1 to WIN1252, but BeginCopyFrom
is neglecting to check for failure of FindDefaultConversionProc.

Will fix that, thanks for the report.

In the meantime, if use of WIN1252 was intentional then you'll need
to find another way to transcode the data that was in that encoding.
Probably, running your database in UTF8 is the best choice -- we
can convert most anything to that.

            regards, tom lane



pgsql-general by date:

Previous
From: Phillip Diffley
Date:
Subject: What changes to a table cannot be detected by a trigger?
Next
From: Ireneusz Pluta
Date:
Subject: Re: Gradual migration from integer to bigint?