Re: BUG #4672: undefined symbol: check_encoding_conversion_args - Mailing list pgsql-bugs

From Boris PIOLINE
Subject Re: BUG #4672: undefined symbol: check_encoding_conversion_args
Date
Msg-id alpine.LFD.2.00.0902231349350.10162@danae.lpthe.jussieu.fr
Whole thread Raw
In response to Re: BUG #4672: undefined symbol: check_encoding_conversion_args  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
List pgsql-bugs
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

pgsql-bugs by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: BUG #4672: undefined symbol: check_encoding_conversion_args
Next
From: artur ganc
Date:
Subject: Link to MS Access