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, same

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

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

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:

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

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 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 yourself,

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)

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

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

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

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

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)