Re: 'query was cancelled' - depending on search pattern - Mailing list pgsql-bugs

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