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

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

From: "Josh Berkus" <josh(at)agliodbs(dot)com>
To: <pgsql-general(at)postgresql(dot)org>, <sfpug(at)postgresql(dot)org>
Subject: Re: [sfpug] Basic problem installing TSearch2 (full text
Date: 2004-12-24 21:24:59
Message-ID: web-6828586@davinci.ethosmedia.com (view raw or flat)
Thread:
Lists: pgsql-generalsfpug
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

In response to

sfpug by date

Next:From: Josh BerkusDate: 2004-12-30 17:52:12
Subject: Fwd: [pgsql-jobs] DBA contract position in Oakland, CA
Previous:From: Jon AsherDate: 2004-12-23 06:34:24
Subject: Basic problem installing TSearch2 (full text search)

pgsql-general by date

Next:From: Martijn van OosterhoutDate: 2004-12-24 23:20:07
Subject: Re: BTree max row size?
Previous:From: Greg StarkDate: 2004-12-24 20:15:00
Subject: Re: default index for primary key of a table

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