Hello
this bug was reported two weeks ago and it is fixed in 8.3.6.
regards
Pavel Stehule
2009/2/11 Howard Cole :
> Hi,
>
> I am in the process of updating a database from 8.2 to 8.3 and need a little
> help with the tsearch2 update.
>
> Prior to restoring my 8.3 backup, I ran the tsearch2.sql o
RTFM!
Just read the part about ditching the tsearch2 function. Sincere apologies.
Howard.
Howard Cole wrote:
execute procedure tsearch2('fts','column1','column2');
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgre
Hi,
I am in the process of updating a database from 8.2 to 8.3 and need a
little help with the tsearch2 update.
Prior to restoring my 8.3 backup, I ran the tsearch2.sql on the new
database, however I am having a little problem with triggers - when I
run an update on a table I get the followi
I am writing a tsearch2 trigger function in plperl. I would like to
run a query similar to this:
setweight(to_tsvector(col1),'b') || setweight(to_tsvector(col2),'a')
and insert the result into the tsvector column. I know I can call
spi_exec_query('select ...') and insert the result, but is this t
Howard Cole wrote:
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
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 colum
On Sat, 16 Oct 2004, Net Virtual Mailing Lists wrote:
Hello,
Thank you to Oleg for your help with this earlier! It resolved it very
nicely!
I still have one remaining issue which I can't figure out, perhaps best
explained with an example:
CREATE TABLE sometable (
titleTEXT,
body TEXT,
foot
Hello,
Thank you to Oleg for your help with this earlier! It resolved it very
nicely!
I still have one remaining issue which I can't figure out, perhaps best
explained with an example:
CREATE TABLE sometable (
titleTEXT,
body TEXT,
footer TEXT,
all_fti TSVECTOR
);
UPDATE sometable
On Fri, 15 Oct 2004, Net Virtual Mailing Lists wrote:
Hello,
I have a table that uses tsearch2 and, of course, and index and trigger
to keep everything updated. Something like:
CREATE TABLE sometable (
id SERIAL,
someinteger INTEGER
sometext TEXT,
sometext2TEXT,
Hello,
I have a table that uses tsearch2 and, of course, and index and trigger
to keep everything updated. Something like:
CREATE TABLE sometable (
id SERIAL,
someinteger INTEGER
sometext TEXT,
sometext2TEXT,
sometext3TEXT,
sometext_fti TSVECTOR
10 matches
Mail list logo