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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bernd von den Brincken <bvdb(at)asa(dot)de>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: 'query was cancelled' - depending on search pattern
Date: 2003-04-03 22:22:41
Message-ID: 14103.1049408561@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Bernd von den Brincken <bvdb(at)asa(dot)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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Bernd von den Brincken 2003-04-03 23:06:35 Re: 'query was cancelled' - depending on search pattern
Previous Message Bernd von den Brincken 2003-04-03 22:17:22 'query was cancelled' - depending on search pattern