On Mon, Aug 8, 2016 at 8:23 AM, Kevin Grittner <kgrittn@xxxxxxxxx> wrote: > Your check for a exclusive self-lock on transactionid should work. > It may be possible to find a way to do it that is less expensive, > so I would definitely encapsulate that in a function; but off-hand > I'm not thinking of a better way. Great, thanks for confirming this. I agree that txid_current() isn't usable for this, but even a "soft" version of it (that doesn't assign an ID) still wouldn't quite be what I'm looking for; Tom's idea of checking for WAL records sounds more like the "proper" solution, in that it more directly checks whether COMMIT would do "real" work, and thus would presumably have fewer false positives. (But that's a guess. AFAICT, creating a temp table also produces WAL records, so perhaps checking for them is no better than checking for a transaction ID after all.) -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
