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

[GENERAL] to_tsvector in 8.2.3

2007-03-21 Thread richardcraig
It may solve my query if anybody can tell me if anything has changes in tsearch2 recently? otherwise... I have two installations of Postgres on Windows machines, one is 8.2.1 and the other is 8.2.3 Both installed the same way, selecting tsearch2 during the installation and restoring the same bac