Return-Path: owner-postman
Received: from localhost.Berkeley.EDU (localhost.Berkeley.EDU [127.0.0.1]) by nobozo.CS.Berkeley.EDU (8.6.10/8.6.3) with SMTP id LAA20692 for postgres-redist; Thu, 9 Mar 1995 11:51:42 -0800
Resent-From: POSTGRES mailing list <postman@postgres.Berkeley.EDU>
Resent-Message-Id: <199503091951.LAA20692@nobozo.CS.Berkeley.EDU>
X-Authentication-Warning: nobozo.CS.Berkeley.EDU: Host localhost.Berkeley.EDU didn't use HELO protocol
Sender: owner-postman@postgres.Berkeley.EDU
X-Return-Path: owner-postman
Received: from eden.CS.Berkeley.EDU (eden.CS.Berkeley.EDU [128.32.37.56]) by nobozo.CS.Berkeley.EDU (8.6.10/8.6.3) with ESMTP id LAA20682 for <postgres@postgres.Berkeley.EDU>; Thu, 9 Mar 1995 11:51:41 -0800
Received: (andrew@localhost) by eden.CS.Berkeley.EDU (8.6.10/8.6.3) id LAA02539; Thu, 9 Mar 1995 11:50:18 -0800
Date: Thu, 9 Mar 1995 11:50:18 -0800
From: "Andrew K. Yu" <andrew@postgres.Berkeley.EDU>
Message-Id: <199503091950.LAA02539@eden.CS.Berkeley.EDU>
To: golder@informatik.uni-wuerzburg.de
Subject: Re:  Problem with regular expression search on text
Cc: postgres@postgres.Berkeley.EDU
Resent-To: postgres-redist@postgres.Berkeley.EDU
Resent-Date: Thu, 09 Mar 95 11:51:42 -0800
Resent-XMts: smtp


> Query sent to backend is "retrieve (c1.all) where c1.id = c2.id and c2.name ~ "J" and 
> c2.id = 3 "
> 
> returns:
> 
> FATAL: no response from backend: detected in PQexec
> 

there is a bug in the optimizer. start the postmaster as follow:
	postmaster -o "-x off"
and the query should run.

-andrew

==============================================================================
   To add/remove yourself to/from the POSTGRES mailing list: send mail with 
   the subject line ADD or DEL to "postgres-request@postgres.Berkeley.EDU".
   If this fails, send mail to "post_questions@postgres.Berkeley.EDU" and
   a human will deal with it.  DO NOT post to the "postgres" mailing list.
==============================================================================
              URL: http://s2k-ftp.CS.Berkeley.EDU:8000/postgres/
