Re: Index trouble with 8.3b4

On Sun, 2008-01-13 at 18:52 -0500, Tom Lane wrote:
> The scan is done using the regular heapscan code, which in 8.3 has been
> modified to enable "synchronized scanning", which means it might start
> from the middle of the table and wrap around.  If that happens, the
> "merge join" will get totally confused because it is expecting the

Thank you and Hannes Dorbath for tracking this down.

> I wonder whether there are any other places that are silently assuming
> that heapscans start from page zero ...
> 

I considered that question when implementing sync scans, but I could not
think of any specific areas of the code that would likely be affected.

Regards,Jeff Davis