Re: BUG #1700: Error on Subselect with date in where condition - Mailing list pgsql-bugs

From Michael Fuhr
Subject Re: BUG #1700: Error on Subselect with date in where condition
Date
Msg-id 20050603140339.GA41223@winnie.fuhr.org
Whole thread Raw
In response to BUG #1700: Error on Subselect with date in where condition  ("Michael" <horsten@aquavital.de>)
List 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/

pgsql-bugs by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: BUG #1698: Different behavior in UNIQUE and DISTINCT
Next
From: "John Hansen"
Date:
Subject: Re: BUG #1698: Different behavior in UNIQUE and DISTINCT