pgsql: Clean up after erroneous SELECT FOR UPDATE/SHARE on a sequence. - Mailing list pgsql-committers

From Tom Lane
Subject pgsql: Clean up after erroneous SELECT FOR UPDATE/SHARE on a sequence.
Date
Msg-id E1QSDdJ-0006DS-DV@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Clean up after erroneous SELECT FOR UPDATE/SHARE on a sequence.

My previous commit disallowed this operation, but did nothing about
cleaning up the damage if one had already been done.  With the operation
disallowed, it's okay to just forcibly clear xmax in a sequence's tuple,
since any value seen there could not represent a live transaction's lock.
So, any sequence-specific operation will repair the problem automatically,
whether or not the user has already seen "could not access status of
transaction" failures.

Branch
------
REL9_0_STABLE

Details
-------
http://git.postgresql.org/pg/commitdiff/bc0550f994539b4cd3b93487439c754e251fedb8

Modified Files
--------------
src/backend/commands/sequence.c |   16 ++++++++++++++++
1 files changed, 16 insertions(+), 0 deletions(-)


pgsql-committers by date:

Previous
From: Tom Lane
Date:
Subject: pgsql: Clean up after erroneous SELECT FOR UPDATE/SHARE on a sequence.
Next
From: Peter Eisentraut
Date:
Subject: pgsql: Sort COMMENT synopsis and add more examples