On 22 October 2017 at 15:00, Eric Ridge <eeb...@gmail.com> wrote: >> On Oct 22, 2017, at 1:50 PM, Peter Geoghegan <p...@bowt.ie> wrote: >> >> On Sun, Oct 22, 2017 at 12:23 PM, Eric Ridge <eeb...@gmail.com> wrote: >>> Can anyone confirm or deny that this is correct? I feel like it is >>> correct, but I'm no expert. >> >> What are you going to use the code for? I think that that context is >> likely to matter here. > > I'm not exactly sure yet, but I'm thinking about storing transaction ids > externally and then regularly poking Postgres to see which ones are > aborted-and-no-longer-considered-visible so I can clean up my external list. >
so, what you want is txid_status() [1]... while this is new in v10 you can use the code as guide or just migrate to v10 ;) [1] https://www.postgresql.org/docs/10/static/functions-info.html#functions-txid-snapshot -- Jaime Casanova www.2ndQuadrant.com PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
