Palle Girgensohn <gir...@pingpong.se> writes:
> I noticed some bad data where end < begin, so I modified these first, and
> tried to vcreate the index in the same transaction. The index creation does
> not notice the data changes. It seems creating the gist index this is not
> transaction safe?
Index creation has to include not-yet-dead tuples in case the index gets
used by some transaction that can still see those tuples. So in this
case index entries get made for both the original and the updated versions
of the tuples in question.
regards, tom lane
