Re: BUG #1700: Error on Subselect with date in where condition

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Michael <horsten(at)aquavital(dot)de>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #1700: Error on Subselect with date in where condition
Date: 2005-06-03 14:03:39
Message-ID: 20050603140339.GA41223@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Fri, Jun 03, 2005 at 01:47:46PM +0100, Michael wrote:
>
> Description: Error on Subselect with date in where condition

Are you sure that "Subselect with date in where condition" accurately
describes the conditions that produce the error? Do you get the
error if you don't use a subselect or if you don't use a date in
the WHERE condition?

> ERROR: cursor "zeoscursor_91bb_610f34f9ac96" does not exist

One possibility is that you're trying to use a cursor outside of the
transaction in which it was declared. "zeoscursor_91bb_610f34f9ac96"
looks automatically generated -- where is it coming from? What
client interface are you using? How are you handling transactions?

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message John Hansen 2005-06-03 14:10:51 Re: BUG #1698: Different behavior in UNIQUE and DISTINCT
Previous Message Bruno Wolff III 2005-06-03 13:58:28 Re: BUG #1698: Different behavior in UNIQUE and DISTINCT