From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | "Jeroen T(dot) Vermeulen" <jtv(at)xs4all(dot)nl> |
Cc: | pgsql-hackers(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org |
Subject: | Re: Cursors and backwards scans and SCROLL |
Date: | 2003-03-10 15:41:33 |
Message-ID: | 17531.1047310893@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-sql |
"Jeroen T. Vermeulen" <jtv(at)xs4all(dot)nl> writes:
>> There are cases where
>> identical cursor definitions might allow or not allow backwards fetch
>> depending on the planner's choices.
> Would it be possible to give warnings in a narrow superset of the
> problematic cases, something along the lines of "I'm scrolling backwards
> for you now, but there's no reason why that should work on this same query
> tomorrow"?
I don't see a practical way to do that --- that little bit of warning
code would have to embed a lot of fragile assumptions about the set of
alternatives searched by the planner. It would probably break every
time we improved the planner. And the breakage would consist either of
failing to give a warning when one is appropriate, or giving a warning
when no other plan is really likely to be chosen; neither of which are
going to be easily noticed or tested for. Seems like a losing game :-(
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2003-03-10 15:43:27 | Re: Who puts the Windows binaries on the FTP server? |
Previous Message | Jeroen T. Vermeulen | 2003-03-10 15:32:46 | Re: Cursors and backwards scans and SCROLL |
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2003-03-10 16:26:00 | Re: Cursors and backwards scans and SCROLL |
Previous Message | Hesham Gowaily | 2003-03-10 15:40:53 | Execution plan problem |