Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group