Postgres Pro
Downloads
Home   >   mailing lists

Thread: Re: [sfpug] Basic problem installing TSearch2 (full text

Re: [sfpug] Basic problem installing TSearch2 (full text

From
"Josh Berkus"
Date:
Jon,

> SHOW server_encoding;
> /* above command displays:  SQL_ASCII   */
> update pg_ts_cfg set locale = 'SQL_ASCII' where ts_name = 'default'

Are you sure your locale is SQL_ASCII and not en_US?

--Josh