Skip site navigation (1) Skip section navigation (2)

Re: ERROR: translation failed from server encoding to wchar_t

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: ilanco(at)gmail(dot)com
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: ERROR: translation failed from server encoding to wchar_t
Date: 2008-01-08 12:53:00
Message-ID: 4783722C.5000503@dunslane.net (view raw or flat)
Thread:
Lists: pgsql-hackers

ilanco(at)gmail(dot)com wrote:
>     NEW.idxFTI := to_tsvector('simple', encode($x$E$x$||
> NEW.messageblk, 'escape'));
>     
>   

I strongly doubt that this does what you think it does - I would check 
the results if I were you. The $x$E$x$ should almost certainly not be 
there - if you are trying to get E'foo' behaviour, that is purely for 
literals. All you are doing here is to prepend a literal 'E' to your value.

cheers

andrew

In response to

pgsql-hackers by date

Next:From: Gregory StarkDate: 2008-01-08 14:13:53
Subject: Psql command-line completion bug
Previous:From: ilancoDate: 2008-01-08 11:49:53
Subject: Re: ERROR: translation failed from server encoding to wchar_t

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group