Re: [GENERAL] to_tsvector in 8.2.3

2007-04-02 Thread Teodor Sigaev
Sorry, no - I tested on CVS HEAD, so dll isn't compatible :( Wait a bit for 8.2.4 richardcraig wrote: Teodor As a non-C windows user (yes - throw stones at me :) ) Do you have a fixed dll for this patch that I can try? Thanks Richard Teodor Sigaev-2 wrote: Solved, see attached patch. I had

Re: [GENERAL] to_tsvector in 8.2.3

2007-04-02 Thread richardcraig
Teodor As a non-C windows user (yes - throw stones at me :) ) Do you have a fixed dll for this patch that I can try? Thanks Richard Teodor Sigaev-2 wrote: > > Solved, see attached patch. I had found old Celeron-300 box and install > Windows > on it, and it was very slow :) > > >> Nope, sa

Re: [GENERAL] to_tsvector in 8.2.3

2007-03-22 Thread Teodor Sigaev
Solved, see attached patch. I had found old Celeron-300 box and install Windows on it, and it was very slow :) Nope, same result with this patch. Thank you. -- Teodor Sigaev E-mail: [EMAIL PROTECTED] WWW: ht

Re: [GENERAL] to_tsvector in 8.2.3

2007-03-22 Thread Magnus Hagander
On Wed, Mar 21, 2007 at 09:13:55PM +0300, Teodor Sigaev wrote: > >postgres=# select to_tsvector('test text'); > > to_tsvector > >--- > > 'test text':1 > >(1 row) > Ok. that's related to > http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/tsearch2/wordparser/parser.c.diff?r1=1.1

Re: [GENERAL] to_tsvector in 8.2.3

2007-03-21 Thread Teodor Sigaev
postgres=# select to_tsvector('test text'); to_tsvector --- 'test text':1 (1 row) Ok. that's related to http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/tsearch2/wordparser/parser.c.diff?r1=1.11;r2=1.12;f=h commit. Thomas pointed that it can be non-breakable space (0xa0) an

Re: [GENERAL] to_tsvector in 8.2.3

2007-03-21 Thread Magnus Hagander
On Wed, Mar 21, 2007 at 04:25:30PM +0300, Teodor Sigaev wrote: > I can't reproduce your problem, but I have not Windows box, can anybody > reproduce that? > > > contrib_regression=# select version(); > version > > PostgreSQL 8.2.3 on i386-unknown-f

Re: [GENERAL] to_tsvector in 8.2.3

2007-03-21 Thread Oleg Bartunov
On Wed, 21 Mar 2007, richardcraig wrote: As an update, I've just copied the tsvector.dll file from an 8.2.1 computer to the 8.2.3 computer and it's working OK now. I suspect a change in the dll is causing the problem. Interesting. Richard richardcraig wrote: Oleg Thanks for the quick

Re: [GENERAL] to_tsvector in 8.2.3

2007-03-21 Thread Teodor Sigaev
8.2 has fully rewritten text parser based on POSIX is* functions. Thomas Pundt wrote: On Wednesday 21 March 2007 14:25, Teodor Sigaev wrote: | I can't reproduce your problem, but I have not Windows box, can anybody | reproduce that? just a guess in the wild; I once had a similar phenomen and tr

Re: [GENERAL] to_tsvector in 8.2.3

2007-03-21 Thread Thomas Pundt
On Wednesday 21 March 2007 14:25, Teodor Sigaev wrote: | I can't reproduce your problem, but I have not Windows box, can anybody | reproduce that? just a guess in the wild; I once had a similar phenomen and tracked it down to a "non breaking space character" (0xA0). Since then I'm patching the tse

Re: [GENERAL] to_tsvector in 8.2.3

2007-03-21 Thread Teodor Sigaev
I can't reproduce your problem, but I have not Windows box, can anybody reproduce that? contrib_regression=# select version(); version PostgreSQL 8.2.3 on i386-unknown-freebsd6.2, compiled by GCC gcc (GCC) 3.4.6 [FreeBSD] 20060305 (1 row) contri

Re: [GENERAL] to_tsvector in 8.2.3

2007-03-21 Thread richardcraig
As an update, I've just copied the tsvector.dll file from an 8.2.1 computer to the 8.2.3 computer and it's working OK now. I suspect a change in the dll is causing the problem. Richard richardcraig wrote: > > Oleg > > Thanks for the quick response. > > On 8.2.1 I get the same result as your

Re: [GENERAL] to_tsvector in 8.2.3

2007-03-21 Thread richardcraig
Oleg Thanks for the quick response. On 8.2.1 I get the same result as yourself, however on 8.2.3 I get (2,"test text") Configuration? Both databases are UTF8 encoded with language set to C Standard windows installation except for tsearch2 I also have another machine with SQL_ASCII encoding on

Re: [GENERAL] to_tsvector in 8.2.3

2007-03-21 Thread Oleg Bartunov
What parse returns ? 8.1.5 and 8.3 return www=# select parse('test text'); parse -- (1,test) (12," ") (1,text) (3 rows) Also, what is your configuration ? On Wed, 21 Mar 2007, richardcraig wrote: It may solve my query if anybody can tell me if anything has changes in tsearch2 r