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: | 20030830222056.74734.qmail@web41015.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
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?
thanks
-w
--- 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
=====
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
From | Date | Subject | |
---|---|---|---|
Next Message | Joseph Shraibman | 2003-08-31 02:19:10 | Re: psql buffering |
Previous Message | Tom Lane | 2003-08-30 22:02:28 | Re: cursor bug |