public inbox for [email protected]  

help / color / mirror / Atom feed

From: Florian Wunderlich <[email protected]>
To: [email protected]
To: [email protected]
Subject: Re: Bug #866 related problem (ATTN Tom Lane)
Date: Tue, 11 Feb 2003 09:39:36 +0100
Message-ID: <[email protected]> (raw)

I can't get through to you because your spam filter blocks my SMTP
relay.

Tom Lane wrote:
> 
> > I now have a quite similar problem: while a CURSOR on a SELECT for a
> > normal query works now, I encounter the same behavior for aggregate
> > queries:
> 
> As I think I pointed out in the original discussion, backwards fetch
> doesn't work for most plan types more complex than a simple sequential
> or index scan.  This is not trivial to fix.
> 
>                         regards, tom lane

I've looked trough our exchange on the list, but there's nothing about
that.

I found another posting which I guess you mean
(http://archives.postgresql.org/pgsql-novice/2002-12/msg00222.php).

I have put a comment in the interactive documentation for now, quoting
your original mail. This really should be in the distributed
documentation for FETCH.

So can I be sure that every non-aggregate SELECT on tables joined with
unique indexes works, independent of the WHERE or ORDER BY?

Is anybody working on implementing this functionality?

Thanks,
Florian Wunderlich

view thread (3+ messages)  latest in thread

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: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: Bug #866 related problem (ATTN Tom Lane)
  In-Reply-To: <[email protected]>

* 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