Re: full text search in 8.3

From: Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>
To: andy <andy(at)squeakycode(dot)net>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: full text search in 8.3
Date: 2007-10-11 05:09:05
Message-ID: 14efcc4600038755@previdencia.gov.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)sai(dot)msu(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Magnus Hagander 2007-10-11 05:46:26 Re: Skytools committed without hackers discussion/review
Previous Message Gokulakannan Somasundaram 2007-10-11 04:58:59 Re: Including Snapshot Info with Indexes