Re: [GENERAL] tsearch2 problems / limitations

2005-02-23 Thread Michael Fuhr
On Tue, Feb 22, 2005 at 01:29:45PM +, James Croft wrote: > One of the tables holds reasonable amounts of text, some fields hold up > to 2Mb. When I try and run > > UPDATE table SET idxfti=to_tsvector('default', field); > > it runs for a while then aborts with the following message > > ERRO

Re: [GENERAL] tsearch2 problems / limitations

2005-02-23 Thread Oleg Bartunov
On Tue, 22 Feb 2005, James Croft wrote: Hi, I've successfully added tsearch2 to an existing database and the speedup of searches is brilliant. I'm now trying to extend this to other parts of our system. One of the tables holds reasonable amounts of text, some fields hold up to 2Mb. When I try a

[GENERAL] tsearch2 problems / limitations

2005-02-22 Thread James Croft
Hi, I've successfully added tsearch2 to an existing database and the speedup of searches is brilliant. I'm now trying to extend this to other parts of our system. One of the tables holds reasonable amounts of text, some fields hold up to 2Mb. When I try and run UPDATE table SET idxfti=to_tsvec