Re: [BUGS] BUG #3767: tsearch2 index creation fatal crash

2007-11-20 Thread Tom Lane
>> I'm not sure that putting in to_tsvector calls there would be an >> improvement, though, since at that point we haven't introduced >> to_tsvector. Uh ... wait a moment ... stop the presses. Thomas is looking at beta1 documentation. CVS HEAD handles this a bit better I think: http://developer.

Re: [BUGS] BUG #3767: tsearch2 index creation fatal crash

2007-11-20 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> I'm not sure that putting in to_tsvector calls there would be an >> improvement, though, since at that point we haven't introduced >> to_tsvector. >> >> Thoughts anyone? > Yep, I saw that chicken and egg problem in the docs when I was

Re: [BUGS] BUG #3767: tsearch2 index creation fatal crash

2007-11-20 Thread Bruce Momjian
Tom Lane wrote: > "Thomas H." <[EMAIL PROTECTED]> writes: > > i saw my mistake. i misinterpreted the examples to show the possibility > > to convert *any* text by using casting to tsvector as an alternative to > > using to_tsvector :) > > Yeah, the examples in section 12.1.2 are not actually goo

Re: [BUGS] BUG #3767: tsearch2 index creation fatal crash

2007-11-20 Thread Tom Lane
"Thomas H." <[EMAIL PROTECTED]> writes: > i saw my mistake. i misinterpreted the examples to show the possibility > to convert *any* text by using casting to tsvector as an alternative to > using to_tsvector :) Yeah, the examples in section 12.1.2 are not actually good practice: both sides of th

Re: [BUGS] BUG #3767: tsearch2 index creation fatal crash

2007-11-20 Thread Thomas H.
there are more problems with tsvectors. this also fails: SELECT ' just a test: 123 '::tsvector; ERROR: syntax error in tsvector: " just a test: 123 " That's not a bug; your input isn't valid tsvector syntax. ok. after re-reading page http://www.postgresql.org/docs/8.3/static/textsearch-i

Re: [BUGS] BUG #3767: tsearch2 index creation fatal crash

2007-11-20 Thread Tom Lane
"Thomas H." <[EMAIL PROTECTED]> writes: > there are more problems with tsvectors. this also fails: > SELECT ' just a test: 123 '::tsvector; > ERROR: syntax error in tsvector: " just a test: 123 " That's not a bug; your input isn't valid tsvector syntax. regards, tom lane

Re: [BUGS] BUG #3767: tsearch2 index creation fatal crash

2007-11-20 Thread Thomas H.
the reported problem below can be reproduced by using this simple query straight from the documentation: SELECT to_tsvector('a fat cat sat on a mat and ate a fat rat'); Works for me: u=# set default_text_search_config = 'pg_catalog.german'; SET u=# SELECT to_tsvector('a fat cat sat on a mat

Re: [BUGS] BUG #3767: tsearch2 index creation fatal crash

2007-11-20 Thread Tom Lane
"Thomas H." <[EMAIL PROTECTED]> writes: > the reported problem below can be reproduced by using this simple query > straight from the documentation: > SELECT to_tsvector('a fat cat sat on a mat and ate a fat rat'); Works for me: u=# set default_text_search_config = 'pg_catalog.german'; SET u=#

Re: [BUGS] BUG #3767: tsearch2 index creation fatal crash

2007-11-20 Thread Thomas H.
the reported problem below can be reproduced by using this simple query straight from the documentation: SELECT to_tsvector('a fat cat sat on a mat and ate a fat rat'); --> postgres.exe dies instantly, with the logs being the same as in the bugreport. interestingly using ::tsvector (which