Re: Incorrect cursor behaviour with gist index

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Teodor Sigaev <teodor(at)sigaev(dot)ru>
Cc: Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org>, Martin Schäfer <Martin(dot)Schaefer(at)cadcorp(dot)com>
Subject: Re: Incorrect cursor behaviour with gist index
Date: 2008-10-17 21:21:25
Message-ID: 18172.1224278485@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Teodor Sigaev <teodor(at)sigaev(dot)ru> writes:
>> to use it when the AM can't guarantee to return the same sequence of
>> tuples after backing up. So I think it would be sufficient to have
>> gistmarkpos et al throw error if called.

> Why not to remove gistrestrpos/gistmarkpos/ginrestrpos/ginmarkpos from pg_am table?

First, because that would mean adding code to the indexam.c functions to
avoid crashing, and second because then we'd have to force initdb to
change our minds about this. I think having stub functions that throw
errors, rather than no catalog entry at all, is cheap future-proofing.

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Nathan Boley 2008-10-17 21:47:31 Re: Cross-column statistics revisited
Previous Message Teodor Sigaev 2008-10-17 21:04:08 Re: Incorrect cursor behaviour with gist index