"Tom Lane" <[EMAIL PROTECTED]> writes:

> Yeah, unfortunately we overlooked the implications of the conversion to
> tsvector being environment-dependent.  Those opclasses will have to go
> away again.  AFAICS the only safe way to build an index directly on a
> text column is
>
> CREATE INDEX idxname ON tblname USING gin (to_tsvector('config', textcolumn));

Is there a null configuration which could be the default for the casts? So the
syntax would still work and would generate an index which worked well but has
no stop words, no stemming, etc?

-- 
  Gregory Stark
  EnterpriseDB          http://www.enterprisedb.com

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Reply via email to