Re: 'query was cancelled' - depending on search pattern

Hello Tom,

At 04.04.2003 00:22, you wrote:
>Bernd von den Brincken <bvdb(at)asa(dot)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