All
I have a recurrent error in my postgres 8.0.4 on redhat 9 (yes, I know
its old - first things first...) server. It only occurs from the
MSAccess/Windows clients I have, not from Java/JDBC or
pgAdminIII/Windows clients; hence the question here.
The log shows (anonymised) up to 6 times a second while a user is
active:
Feb 8 16:03:28 (server) postgres[8625]: [7-1] 2006-02-08
16:03:28 GMT (user)(database) ERROR: conversion between latin9 and
LATIN1 is not supported.
Now, I have added statement debugging to the log together with a "set
client_encoding to 'latin1'" in the ODBC driver, and got this:
Feb 8 15:48:18 (server) postgres[8277]: [6-1] 2006-02-08
15:48:18 GMT (user) (database) LOG: statement: select version()
Feb 8 15:48:18 (server) postgres[8277]: [7-1] 2006-02-08
15:48:18 GMT (user) (database) LOG: statement: set DateStyle to 'ISO'
Feb 8 15:48:18 (server) postgres[8277]: [8-1] 2006-02-08
15:48:18 GMT (user) (database) LOG: statement: set geqo to 'OFF'
Feb 8 15:48:18 (server) postgres[8277]: [9-1] 2006-02-08
15:48:18 GMT (user) (database) LOG: statement: set extra_float_digits
to 2
Feb 8 15:48:18 (server) postgres[8277]: [10-1] 2006-02-08
15:48:18 GMT (user) (database) LOG: statement: set client_encoding to
'latin1'
Feb 8 15:48:18 (server) postgres[8277]: [11-1] 2006-02-08
15:48:18 GMT (user) (database) LOG: statement: select oid from pg_type
where typname='lo'
Feb 8 15:48:18 (server) postgres[8277]: [12-1] 2006-02-08
15:48:18 GMT (user) (database) LOG: statement: select
pg_client_encoding()
Feb 8 15:48:18 (server) postgres[8277]: [13-1] 2006-02-08
15:48:18 GMT (user) (database) LOG: statement: set client_encoding to
'latin9'
Feb 8 15:48:18 (server) postgres[8277]: [14-1] 2006-02-08
15:48:18 GMT (user) (database) ERROR: conversion between latin9 and
LATIN1 is not supported
You can clearly see my latin1 request followed shortly by the latin9. I
have examined the ODBC code and it looks like the culprit is a code page
of 1252.
Am I tracing this right? What do I do about? Suggestions, please!
Tim Clarke