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

From Tom Lane
Subject Re: 'query was cancelled' - depending on search pattern
Date
Msg-id 14103.1049408561@sss.pgh.pa.us
Whole thread Raw
In response to 'query was cancelled' - depending on search pattern  (Bernd von den Brincken <bvdb@asa.de>)
Responses Re: 'query was cancelled' - depending on search pattern  (Bernd von den Brincken <bvdb@asa.de>)
List pgsql-bugs
Bernd von den Brincken <bvdb@asa.de> writes:
> a query that uses pattern matching like this:
>    SELECT .. WHERE  ( (content || authorname) ~* ( '.*gesellschaft.* |
> .*wirtschaft.*' ) )
> 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?

            regards, tom lane

pgsql-bugs by date:

Previous
From: Bernd von den Brincken
Date:
Subject: 'query was cancelled' - depending on search pattern
Next
From: Bernd von den Brincken
Date:
Subject: Re: 'query was cancelled' - depending on search pattern