Обсуждение: pgsql: Handle duplicate XIDs in txid_snapshot.

Поиск
Список
Период
Сортировка

pgsql: Handle duplicate XIDs in txid_snapshot.

От
Heikki Linnakangas
Дата:
Handle duplicate XIDs in txid_snapshot.

The proc array can contain duplicate XIDs, when a transaction is just being
prepared for two-phase commit. To cope, remove any duplicates in
txid_current_snapshot(). Also ignore duplicates in the input functions, so
that if e.g. you have an old pg_dump file that already contains duplicates,
it will be accepted.

Report and fix by Jan Wieck. Backpatch to all supported versions.

Branch
------
REL8_4_STABLE

Details
-------
http://git.postgresql.org/pg/commitdiff/56693cfb30911cd46c9759e129a047aa9d03b945

Modified Files
--------------
src/backend/utils/adt/txid.c       |   59 ++++++++++++++++++++++++++++--------
src/test/regress/expected/txid.out |   10 +++---
src/test/regress/sql/txid.sql      |    2 +-
3 files changed, 54 insertions(+), 17 deletions(-)