Seamless age (xid) replacement - Mailing list pgsql-general

From Ivan Shershnev
Subject Seamless age (xid) replacement
Date
Msg-id CAJjhk3Divm6hpx395nJFdN2J_ytpFVbmOp00GWOtE7D=ppVzAA@mail.gmail.com
Whole thread Raw
Responses Re: Seamless age (xid) replacement
List pgsql-general
Hello!

I need to use the 'age (xid)' function, but I have noticed that it is deprecated without a clear alternative. I know that xid is also kinda deprecated, so it makes sense not to use it. I can get xid8 from 'pg_current_xact_id()', which replaced 'txid_current()', but cannot use it right away with 'age'.

I can cast xid8 that I've got to xid and pass to 'age', but 1) I have no idea if it's the right way, i.e. it's promised to work or will work anyway by accident, 2) 'age' is anyway deprecated.

I can re-implement 'age' by myself. It's (mostly) a subtraction after all. But it would mean that I inline implementation in place of "api" function call which is not always a great idea.

Could anyone advise, please?

Kind regards,
Ivan

pgsql-general by date:

Previous
From: Greg Sabino Mullane
Date:
Subject: Re: Help in vetting my steps for Postgres DB upgrade from Ver 13.X to ver 15.X
Next
From: Adrian Klaver
Date:
Subject: Re: Help in vetting my steps for Postgres DB upgrade from Ver 13.X to ver 15.X