Re: ERROR: translation failed from server encoding to wchar_t - Mailing list pgsql-hackers
From | ilanco@gmail.com |
---|---|
Subject | Re: ERROR: translation failed from server encoding to wchar_t |
Date | |
Msg-id | 72972bae-bfa7-401e-b74d-e930915ffa2d@i72g2000hsd.googlegroups.com Whole thread Raw |
In response to | ERROR: translation failed from server encoding to wchar_t (ilanco@gmail.com) |
List | pgsql-hackers |
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 idxFTI=to_tsvector('simple', encode(messageblk, 'escape')) where messageblk_idnr = 12949; UPDATE 1 dbname=> select * from dbmail_messageblks where messageblk_idnr = 12949;messageblk_idnr | physmessage_id | messageblk | blocksize | is_header | idxfti -----------------+---------------- +---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- +-----------+----------- +------------------------------------------------------------------------------------------------- 12949 | 6319 | l'\351quipe de Casinos-park a bien re\347u votre messsage. \012\012Vous aurez une r\351ponse d\350s que l'un de nos responsables aura pris connaissance de votre envoi. \012\012cordialement\012\012l'\351quipe de casinos-park. \012\012====================\012\012The team of Casinos-park received your messsage.\012\012You will have an answer as soon as one of our persons in charge takes note of your sending. \012\012Best regards \012\012The team of casinos-park.\012 | 398 | 0 | '=':3 'e':5 'h':11 'i':2,10 'k':12 'l':1 'o':7 'p':9,16 'r':8 's':6 't':13 'u':15 'y':14 'rk':4 (1 row) dbname=> UPDATE dbmail_messageblks SET idxFTI=to_tsvector('simple', encode(messageblk, 'escape')) where messageblk_idnr = 12949; ERROR: translation failed from server encoding to wchar_t dbname=> UPDATE dbmail_messageblks SET idxFTI=to_tsvector('simple', encode(messageblk, 'escape')) where messageblk_idnr = 12949; UPDATE 1 On Jan 7, 10:21 pm, ila...@gmail.com wrote: > 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 SET idxFTI=to_tsvector('simple', > encode(messageblk, 'escape')) where messageblk_idnr = 12949; > UPDATE 1 > > The to_tsvector seems to accept the row at random ... > > On Jan 7, 9:16 pm, ila...@gmail.com wrote: > > > 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 tsearch2 it worked perfectly ... > > > Thanks for you help, > > > ilan
pgsql-hackers by date: