Re: full text search in 8.3 - Mailing list pgsql-hackers

From Oleg Bartunov
Subject Re: full text search in 8.3
Date
Msg-id 14efcc4600038755@previdencia.gov.br
Whole thread Raw
In response to Re: full text search in 8.3  (andy <andy@squeakycode.net>)
List pgsql-hackers
Andy,

seems you're a right person for writing migration guide.

Oleg
On Wed, 10 Oct 2007, andy wrote:

> andy wrote:
>> Andy Colson wrote:
>>> Hi All,
>>> 
>>> You knew it was coming....
>>> 
>>> 
>>> I tried doing a pg_dump --schema-only and restoring just that, but still 
>>> got a bunch of errors (those above).  If I clean that up of all the old 
>>> text search stuff, and then run it, then do the data, will that work ok?
>>> 
>> 
>> Further to this, I edited the schema, and created it ok, then dumped the 
>> data across (after editing out all the tsearch stuff).  So far so good.
>> 
>> However, my trigger failed:
>> 
>> CREATE TRIGGER fulltext_update
>>     BEFORE INSERT OR UPDATE ON times
>>     FOR EACH ROW
>>     EXECUTE PROCEDURE tsearch2('vectors', 'remarks');
>> 
>> Looks like we renamed/removed the tsearch2 function?  Is 
>> setweight(to_tsvector()) the new way?
>> 
>> -Andy
>
> Ah, found it.. in the doc's no less :-)
>
> CREATE TRIGGER tsvectorupdate BEFORE INSERT OR UPDATE
> ON tblMessages FOR EACH ROW EXECUTE PROCEDURE
> tsvector_update_trigger(tsv, 'pg_catalog.english', strMessage);
>
> -Andy
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>
    Regards,        Oleg
_____________________________________________________________
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)939-23-83

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
              http://archives.postgresql.org


pgsql-hackers by date:

Previous
From: "Florian G. Pflug"
Date:
Subject: Re: Plan invalidation vs temp sequences
Next
From: Tom Lane
Date:
Subject: Re: Debugger