On Jan 8, 4:14 am, [EMAIL PROTECTED] (Tom Lane) wrote:
[EMAIL PROTECTED] writes:
I am using tsearch2 with pgsql 8.2.5 and get the following error when
calling to_tsvector :
translation failed from server encoding to wchar_t
My database is UTF8 encoded and the data sent to to_tsvector
On Jan 8, 10:43 am, [EMAIL PROTECTED] wrote:
On Jan 8, 4:14 am, [EMAIL PROTECTED] (Tom Lane) wrote:
[EMAIL PROTECTED] writes:
I am using tsearch2 with pgsql 8.2.5 and get the following error when
calling to_tsvector :
translation failed from server encoding to wchar_t
My database
I am using tsearch2 with pgsql 8.2.5 and get the following error when
calling to_tsvector :
translation failed from server encoding to wchar_t
My database is UTF8 encoded and the data sent to to_tsvector comes
from a bytea column converted to text with
encode(COLUMN, 'escape').
In 8.1 with
http://pastebin.ca/845670
This url provides a testcase ...
fisrt pass :
= UPDATE dbmail_messageblks SET idxFTI=to_tsvector('simple',
encode(messageblk, 'escape')) where messageblk_idnr = 12949;
ERROR: translation failed from server encoding to wchar_t
second pass :
= UPDATE dbmail_messageblks
Found something interesting with this testcase.
update fails after SELECT query.
Can anyone confirm this ???
dbname= UPDATE dbmail_messageblks SET idxFTI=to_tsvector('simple',
encode(messageblk, 'escape')) where messageblk_idnr = 12949;
UPDATE 1
dbname= UPDATE dbmail_messageblks SET