| 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. jednatel Mediawork group s.r.o. email: radek.novotny@xxxxxxxxxxxx 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.novotny@xxxxxxxxxxxx> > > 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.novotny@xxxxxxxxxxxx > > http://www.mediawork.cz |
