Re: Batch INSERT failing with error 22P02

Поиск
Список
Период
Сортировка
От Dave Cramer
Тема Re: Batch INSERT failing with error 22P02
Дата
Msg-id 3FB6F105-AFD2-4BFC-8FF3-9CF24126C638@fastcrypt.com
обсуждение исходный текст
Ответ на Batch INSERT failing with error 22P02  (Eric Faulhaber <ecf@goldencode.com>)
Ответы Re: Batch INSERT failing with error 22P02  (Eric Faulhaber <ecf@goldencode.com>)
Список pgsql-jdbc
>
> So, my questions:
>
> A) Can anyone think what might have changed between the 8.1-408 and
> 8.2-506 versions of the JDBC driver which might result in an
> INVALID TEXT REPRESENTATION (22P02) error?
I seem to recall the backend becoming more restrictive on valid UTF
sequences. However that doesn't make sense if an 8.1 driver does
work. Any chance we can get the server logs ?
>
> B) While the JDBC drivers are documented to be backward compatible
> with older back-ends, is there anything that would make it
> obviously unsafe for me to go the other way round, using the 8.1
> JDBC driver with the 8.2.4 back-end?  Although this doesn't seem to
> be a viable permanent solution, for the time being I have no
> working alternative for PG 8.2.4.
>
Iyou can do this if the code is just doing select/insert/update/
delete in other words nothing fancy.
> Thanks in advance,
> Eric Faulhaber
>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
>               http://archives.postgresql.org


В списке pgsql-jdbc по дате отправления:

Предыдущее
От: Eric Faulhaber
Дата:
Сообщение: Batch INSERT failing with error 22P02
Следующее
От: Kris Jurka
Дата:
Сообщение: Re: Batch INSERT failing with error 22P02