From: | Howard Cole <howard(dot)cole(at)selestial(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | tsearch2 Trigger |
Date: | 2005-02-07 17:35:46 |
Message-ID: | 4207A6F2.20408@selestial.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
I have succussfully managed to install tsearch2 and can use it happily
with selects, ts_vectors etc. My only problem is when using a trigger in
the form suggested in the intro documentation.
The trigger calls a function "tsearch2" which takes the tsvector column
name, and the names of columns that the full text search is composed of.
Unfortunately, In my web application, I need to call "select
set_curcfg('default')" before every insert/update operation or I get an
error about the locale.
This is not a problem with searching, because I can force the locale by
entering the configuration in the select command (e.g.
to_tsquery('default', search)).
Can I force the command in the tsearch2 function, or can I permanently
set the config?
Thanks.
Howard Cole
www.selestial.com
From | Date | Subject | |
---|---|---|---|
Next Message | Martijn van Oosterhout | 2005-02-07 18:07:15 | Re: Creating an index-type for LIKE '%value%' |
Previous Message | Joshua D. Drake | 2005-02-07 17:34:38 | Re: tsearch2 Trigger |