Horton

Add a txid_status function.

Robert Haas <rhaas@postgresql.org>

View on postgr.es
Commit: 857ee8e391ff6654ef9dcc5dd8b658d7709d0a3c
Author: Robert Haas <rhaas@postgresql.org>
Date: 2017-03-24T16:00:53Z
Releases: 10.0 
Add a txid_status function.

If your connection to the database server is lost while a COMMIT is
in progress, it may be difficult to figure out whether the COMMIT was
successful or not.  This function will tell you, provided that you
don't wait too long to ask.  It may be useful in other situations,
too.

Craig Ringer, reviewed by Simon Riggs and by me

Discussion: http://postgr.es/m/CAMsr+YHQiWNEi0daCTboS40T+V5s_+dst3PYv_8v2wNVH+Xx4g@mail.gmail.com

Files

PathChange+/−
doc/src/sgml/func.sgml modified +27 −0
src/backend/utils/adt/txid.c modified +132 −0
src/include/catalog/catversion.h modified +1 −1
src/include/catalog/pg_proc.h modified +2 −0
src/test/recovery/t/011_crash_recovery.pl added +46 −0
src/test/regress/expected/txid.out modified +68 −0
src/test/regress/sql/txid.sql modified +38 −0

Documentation touched

Discussion