At 04.04.2003 00:22, you wrote:
Bernd von den Brincken <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
