Re: integration of fulltext search in bytea/docs

Is there possible to create pg trigger that runs shell script?
--

www.publicstream.cz - vytvořili jsme produkt pro živé přenosy (online streaming)
a videoarchív ve formátu FLASH.

Bc. Radek Novotný
jednatel Mediawork group s.r.o.

tel.: +420 724 020 361
email: radek(dot)novotny(at)mediawork(dot)cz
http://www.mediawork.cz

Dne St 29. července 2009 17:38:31 Pavel Stehule napsal(a):
> Hello
>
> Dne 29. červenec 2009 16:46 Radek Novotný <radek(dot)novotny(at)mediawork(dot)cz>
>
> napsal(a):
> > Hello,
> > is there in the roadmap of postgre integration of fulltext searching in
> > documents saved in blobs (bytea)?
>
> What I know, no. PostgreSQL doesn't know about others binary formats,
> so it cannot do it.
>
> > For example linux antiword can export fine text output that can be
> > inserted into varchar field.
>
> I understand it well. Three years ago, we used antiword. We stored two
> values - bytea - original word doc, and text - antiword output. The
> overhead is minimal, and this solution worked very well.
>
> > Would be very very nice (postgre users can be proud to be first) to save
> > documents into bytea and search that field via to_tsvector, to_tsquery
> > ...
>
> It's should be very slow. You have to do repeated transformation.
>
> Pavel Stehule
>
> > --
> >
> > www.publicstream.cz - vytvořili jsme produkt pro živé přenosy (online
> > streaming) a videoarchív ve formátu FLASH.
> >
> > Bc. Radek Novotný
> > jednatel Mediawork group s.r.o.
> >
> > tel.: +420 724 020 361
> > email: radek(dot)novotny(at)mediawork(dot)cz
> > http://www.mediawork.cz