Hello Tom,
At 04.04.2003 00:22, you wrote:
>Bernd von den Brincken <bvdb@asa.de> writes:
> > a query ... produces an error 'Query was cancelled' -
> > sometimes, depending on the search words.
>
>That's really, really hard to believe. I suspect you've mis-analyzed
>the situation. You sure your client-side code doesn't send cancel
>requests on occasion? Can you create a test case that would let someone
>else reproduce this behavior?
I stripped the query down a bit - this one produces the cancel:
SELECT id FROM cftext WHERE ( content ~* ( '.*wirt.* | .*weil.*'
) ) ;
Whereas this one provides a correct result set:
SELECT id FROM cftext WHERE ( content ~* ( '.*wirt.* | .*und.*' ) ) ;
My client is psql via telnet on a Toshiba T550 laptop, my version():
PostgreSQL 7.3.2 on i386-portbld-freebsd4.7, compiled by GCC 2.95.4
Now I tested it on a different machine (P-3 Server) with (almost) the same
DB contents - it works fine there ! - The version() says:
PostgreSQL 7.3 on i386-unknown-freebsd4.5, compiled by GCC 2.95.3
So may the problem be in the pattern matching code that may differ
between freebsd versions?
Regards
// Bernd vdB