TSearch2 / UTF-8 and stat() function

From: Hannes Dorbath <light(at)theendofthetunnel(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: TSearch2 / UTF-8 and stat() function
Date: 2005-11-23 10:21:19
Message-ID: dm1fov$582$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Another UTF-8 thing I forgot:

fts=# SELECT * FROM stat('SELECT to_tsvector(''simple'', line) FROM fts;');
ERROR: invalid byte sequence for encoding "UNICODE": 0xe2a7

The query inside the stat() function alone works fine. I have not set
any client encoding. What breaks it? It works as long the inside query
does not return UTF-8 in vectors.

Thanks.

--
Regards,
Hannes Dorbath

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Oleg Bartunov 2005-11-23 10:31:26 Re: tsearch2: more than one index per table?
Previous Message Martijn van Oosterhout 2005-11-23 10:05:39 Re: PREPARE in bash scripts