Re: [HACKERS] How to determine that a TransactionId is really aborted?

On 22 October 2017 at 15:00, Eric Ridge <eebbrr@gmail.com> wrote:
>> On Oct 22, 2017, at 1:50 PM, Peter Geoghegan <pg@bowt.ie> wrote:
>>
>> On Sun, Oct 22, 2017 at 12:23 PM, Eric Ridge <eebbrr@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
Postgresto 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