Re: cache lookup failed for function 0

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: cache lookup failed for function 0
Дата
Msg-id 1717206.1696170753@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: cache lookup failed for function 0  (pf@pfortin.com)
Список 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 по дате отправления:

Предыдущее
От: Phillip Diffley
Дата:
Сообщение: What changes to a table cannot be detected by a trigger?
Следующее
От: Ireneusz Pluta
Дата:
Сообщение: Re: Gradual migration from integer to bigint?