agora inbox for postgres@postgres.berkeley.edu  

help / color / mirror / Atom feed

From: Andrew K. Yu <andrew@postgres.Berkeley.EDU>
To: golder@informatik.uni-wuerzburg.de
Cc: postgres@postgres.Berkeley.EDU
Subject: Re:  Problem with regular expression search on text
Date: Thu, 9 Mar 1995 11:50:18 -0800
Message-ID: <199503091950.LAA02539@eden.CS.Berkeley.EDU> (raw)


> 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/

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: postgres@postgres.berkeley.edu
  Cc: andrew@postgres.Berkeley.EDU, golder@informatik.uni-wuerzburg.de
  Subject: Re:  Problem with regular expression search on text
  In-Reply-To: <199503091950.LAA02539@eden.CS.Berkeley.EDU>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox