Skip site navigation (1) Skip section navigation (2)

Re: integration of fulltext search in bytea/docs

From: Radek Novotný <radek(dot)novotny(at)mediawork(dot)cz>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: integration of fulltext search in bytea/docs
Date: 2009-07-30 13:09:12
Message-ID: 200907301509.12817.radek.novotny@mediawork.cz (view raw or flat)
Thread:
Lists: pgsql-general
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

In response to

Responses

pgsql-general by date

Next:From: Sam MasonDate: 2009-07-30 13:18:01
Subject: Re: integration of fulltext search in bytea/docs
Previous:From: Scott MeadDate: 2009-07-30 12:31:04
Subject: Re: Slony and local machine slave..(supernewbie question)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group