tsearch2 Trigger - Mailing list pgsql-general

From Howard Cole
Subject tsearch2 Trigger
Date
Msg-id 4207A6F2.20408@selestial.com
Whole thread Raw
Responses Re: tsearch2 Trigger
List 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

pgsql-general by date:

Previous
From: Clodoaldo Pinto
Date:
Subject: Out of memory error
Next
From: Michael Fuhr
Date:
Subject: Re: PostgreSQL, exception and PHP