patrick wrote:
Can you identify which row(s) are causing this problem? If we have the
value that's causing this, someone can reproduce it.
i have only 1 row:
46; "the product name"; "the description";
i don't see any specials chars or accents.
I think I've reproduced it here, and it's not your data.
knowing that some of my clients are french, should i use LATIN9 as
database encoding / client encoding? or maybe it's because of the LOCALE
(French/Canada)?
UPDATE product SET search_vector = setweight(to_tsvector(name), 'A') ||
to_tsvector(description);
It's your script. It's got a character that's not UTF8 and you've told
the system that's what your client_encoding is. I think it's "|".
See if you can reproduce it with: SELECT 'abc'::text || 'def::text;
I got the error by editing the script at a command-prompt. If you use
notepad or some other MS-Windows (TM) based editor it should let you
choose ANSI as the format to save in.
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
