Thanks a lot for the quick reply:
> Boris wrote:
>> The following bug has been logged online:
>>
>> Bug reference: 4672
>> Logged by: Boris
>> Email address: pioline@lpthe.jussieu.fr
>> PostgreSQL version: 8.3.6
>> Operating system: Linux
>> Description: undefined symbol: check_encoding_conversion_args
>> Details:
>> I recently upgraded to 8.3.6, as a result of which encoding conversion does
>> not seem to work anymore:
>>
>> $ export PGCLIENTENCODING=ISO-8859-1
>> $ psql
>> psql: FATAL: could not load library
>> "/usr/lib/pgsql/utf8_and_iso8859_1.so":
>> /usr/lib/pgsql/utf8_and_iso8859_1.so: undefined symbol:
>> check_encoding_conversion_args
>>
>> My database is in UTF8, if I run the same with export PGCLIENTENCODING=UTF8
>> everything works fine.
>
> check_encoding_conversion_args is a new internal function in 8.3.6. I suspect
> that there's a mismatch in the version of PostgreSQL and the associated
> encoding conversion libraries. Since you upgraded to 8.3.6, have you
> restarted PostgreSQL? What does "SELECT version()" say?
You're right, that fixed the pb. However I still get a conversion error
from UTF8 into ISO-8859-1::
"Couldn't execute statement: ERROR: character 0xe28099 of encoding "UTF8"
has no equivalent in "LATIN1"
SELECT version returns
PostgreSQL 8.3.6 on i386-redhat-linux-gnu, compiled by GCC gcc (GCC) 4.3.0
20080428 (Red Hat 4.3.0-8)
Thanks for any help.
Regards,
Boris