Re: [GENERAL] Tsearch2 Trigger Problem: pg_catalog.simple does not exist

2009-02-11 Thread Pavel Stehule
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

Re: [GENERAL] Tsearch2 Trigger Problem: pg_catalog.simple does not exist

2009-02-11 Thread Howard Cole
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

[GENERAL] Tsearch2 Trigger Problem: pg_catalog.simple does not exist

2009-02-11 Thread 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 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

[GENERAL] tsearch2 trigger

2005-04-21 Thread Joel Leyh
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

Re: [GENERAL] tsearch2 Trigger

2005-02-07 Thread Joshua D. Drake
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

[GENERAL] tsearch2 Trigger

2005-02-07 Thread Howard Cole
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

Re: [GENERAL] Tsearch2 trigger firing...

2004-10-16 Thread Oleg Bartunov
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

Re: [GENERAL] Tsearch2 trigger firing...

2004-10-16 Thread Net Virtual Mailing Lists
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

Re: [GENERAL] Tsearch2 trigger firing...

2004-10-15 Thread Oleg Bartunov
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,

[GENERAL] Tsearch2 trigger firing...

2004-10-15 Thread Net Virtual Mailing Lists
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