[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: [GENERAL] cursor bug
From:       <washingtonirving () yahoo ! com>
Date:       2003-08-30 22:20:56
[Download RAW message or body]

Thanks for the quick reply. Couple questions:
- when is 7.4 expected?
- what is the overhead in declaring a cursor scroll? time? space?

thanks
-w

--- Tom Lane <tgl@sss.pgh.pa.us> wrote:
> <washingtonirving@yahoo.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


=====
http://www.kurukshetra.org
Discuss news and opinions on India.

__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
[prev in list] [next in list] [prev in thread] [next in thread]