From 13ff51baf282ee4bd49036c82625a36007e0f233 Mon Sep 17 00:00:00 2001 From: Teodor Sigaev Date: Tue, 30 Aug 2005 07:57:48 +0000 Subject: Fix missing rows in query update a=.. where a... with GiST index on column 'a' --- src/backend/access/gist/gistget.c | 18 +++++++++++++----- 1 file changed, 13 insertions(+), 5 deletions(-) (limited to 'src/backend/access/gist/gistget.c') diff --git a/src/backend/access/gist/gistget.c b/src/backend/access/gist/gistget.c index 70febc584c4..aa0260c6ad6 100644 --- a/src/backend/access/gist/gistget.c +++ b/src/backend/access/gist/gistget.c @@ -8,7 +8,7 @@ * Portions Copyright (c) 1994, Regents of the University of California * * IDENTIFICATION - * $PostgreSQL: pgsql/src/backend/access/gist/gistget.c,v 1.43 2004/12/31 21:59:10 pgsql Exp $ + * $PostgreSQL: pgsql/src/backend/access/gist/gistget.c,v 1.43.4.1 2005/08/30 07:57:48 teodor Exp $ * *------------------------------------------------------------------------- */ @@ -167,10 +167,18 @@ gistnext(IndexScanDesc s, ScanDirection dir) maxoff = PageGetMaxOffsetNumber(p); po = (GISTPageOpaque) PageGetSpecialPointer(p); - if (ScanDirectionIsBackward(dir)) - n = OffsetNumberPrev(stk->gs_child); - else - n = OffsetNumberNext(stk->gs_child); + if ( stk->gs_child == InvalidOffsetNumber ) { + /* rescan page */ + if (ScanDirectionIsBackward(dir)) + n = PageGetMaxOffsetNumber(p); + else + n = FirstOffsetNumber; + } else { + if (ScanDirectionIsBackward(dir)) + n = OffsetNumberPrev(stk->gs_child); + else + n = OffsetNumberNext(stk->gs_child); + } so->s_stack = stk->gs_parent; pfree(stk); -- cgit v1.2.3