Hannu Krosing <hannu(at)tm(dot)ee> writes:
> But
> http://www.postgresql.org/idocs/index.php?sql-syntax-columns.html
That documentation is in error (my fault). Current docs say
xmax
The identity (transaction ID) of the deleting transaction, or zero
for an undeleted tuple. It is possible for this field to
be nonzero in a visible tuple: that usually indicates that the
deleting transaction hasn't committed yet, or that an
attempted deletion was rolled back.
> I also think that this kas historically been the behaviour
No, it wasn't.
regards, tom lane