Re: A thought on Index Organized Tables - Mailing list pgsql-hackers

From Tom Lane
Subject Re: A thought on Index Organized Tables
Date
Msg-id 9818.1267143664@sss.pgh.pa.us
Whole thread Raw
In response to Re: A thought on Index Organized Tables  (Karl Schnaitter <karlsch@gmail.com>)
Responses Re: A thought on Index Organized Tables
List pgsql-hackers
Karl Schnaitter <karlsch@gmail.com> writes:
> Of course, PG can't "support" indexing with incorrect functions. However,
> it's worthwhile to guard against too much damage being done if the user's
> function has a bug. Maybe I'm wrong? Maybe an index tuple with a dangling
> pointer is actually harmless?

No, it's far from harmless.  As soon as that heap TID gets filled with
an unrelated tuple, you run the risk of indexscans alighting on and
perhaps modifying the wrong tuple.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: psql with "Function Type" in \df
Next
From: Bruce Momjian
Date:
Subject: Re: A thought: should we run pgindent now?