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

Re: Missing results from scroll cursor in PostgreSQL 8.3.3?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Simon Riggs <simon(at)2ndQuadrant(dot)com>
Cc: Mark Cave-Ayland <mark(dot)cave-ayland(at)siriusit(dot)co(dot)uk>, pgsql-hackers(at)postgresql(dot)org, Teodor Sigaev <teodor(at)sigaev(dot)ru>
Subject: Re: Missing results from scroll cursor in PostgreSQL 8.3.3?
Date: 2008-09-25 18:01:45
Message-ID: 9506.1222365705@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
Simon Riggs <simon(at)2ndQuadrant(dot)com> writes:
> Seems like GIST should be able to fake a backwards scan if needed.

Well, it tries --- there is logic in there that pays attention to the
scan direction.  Like I say, I don't know the extent of the difficulty.

If we were to decide that it's unfixable, the right thing would be to
have the planner stick a materialize node on top, rather than invent
a specialized kluge for GIST.

			regards, tom lane

In response to

pgsql-hackers by date

Next:From: Bruce MomjianDate: 2008-09-25 19:56:51
Subject: Re: Updates of SE-PostgreSQL 8.4devel patches
Previous:From: Simon RiggsDate: 2008-09-25 17:56:54
Subject: Re: Missing results from scroll cursor in PostgreSQL8.3.3?

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