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

Поиск
Список
Период
Сортировка
От Michael Fuhr
Тема Re: BUG #1700: Error on Subselect with date in where condition
Дата
Msg-id 20050603140339.GA41223@winnie.fuhr.org
обсуждение исходный текст
Ответ на BUG #1700: Error on Subselect with date in where condition  ("Michael" <horsten@aquavital.de>)
Список 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 по дате отправления:

Предыдущее
От: Bruno Wolff III
Дата:
Сообщение: Re: BUG #1698: Different behavior in UNIQUE and DISTINCT
Следующее
От: "John Hansen"
Дата:
Сообщение: Re: BUG #1698: Different behavior in UNIQUE and DISTINCT