Skip site navigation (1) Skip section navigation (2)

Re: cursor bug

From: <washingtonirving(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: cursor bug
Date: 2003-08-30 22:20:56
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-general
Thanks for the quick reply. Couple questions:
- when is 7.4 expected?
- what is the overhead in declaring a cursor scroll? time? space?


--- Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> <washingtonirving(at)yahoo(dot)com> writes:
> > Under some cases, using cursors and the fetch and move commands don't
> > work as expected.
> Moving backwards in complex queries (anything more complex than a single
> table scan) doesn't work reliably in releases before 7.4.  In 7.4 you
> can do it, but you'll usually have to specifically declare the cursor
> as SCROLL ... and eat the ensuing overhead ...
> 			regards, tom lane
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings

Discuss news and opinions on India.

Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software

In response to

pgsql-general by date

Next:From: Joseph ShraibmanDate: 2003-08-31 02:19:10
Subject: Re: psql buffering
Previous:From: Tom LaneDate: 2003-08-30 22:02:28
Subject: Re: cursor bug

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group