MIME-Version: 1.0
From: Ivan Shershnev <ivan.shershnev@jetbrains.com>
Date: Wed, 4 Dec 2024 16:51:41 +0100
Message-ID: <CAJjhk3Divm6hpx395nJFdN2J_ytpFVbmOp00GWOtE7D=ppVzAA@mail.gmail.com>
Subject: Seamless age (xid) replacement
To: pgsql-general@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000a1be06062873c294"
Archived-At: <https://www.postgresql.org/message-id/CAJjhk3Divm6hpx395nJFdN2J_ytpFVbmOp00GWOtE7D%3DppVzAA%40mail.gmail.com>
Precedence: bulk

--000000000000a1be06062873c294
Content-Type: text/plain; charset="UTF-8"

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

--000000000000a1be06062873c294
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div>Hello!</div><div><br></div><div>I need to use the =
9;age (xid)&#39; 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 &#39;pg_current_xact_id()&#39;, w=
hich replaced &#39;txid_current()&#39;, but cannot use it right away with &=
#39;age&#39;.</div><div><br></div><div>I can cast xid8 that I&#39;ve got to=
 xid and pass to &#39;age&#39;, but 1) I have no idea if it&#39;s the right=
 way, i.e. it&#39;s promised to work or will work anyway by accident, 2) &#=
39;age&#39; is anyway deprecated.</div><div><br></div><div>I can re-impleme=
nt &#39;age&#39; by myself. It&#39;s (mostly) a subtraction after all. But =
it would mean that I inline implementation in place of &quot;api&quot; func=
tion call which is not always a great idea.</div><div><br></div><div>Could =
anyone advise, please?</div><div><br></div><div>Kind regards,</div><div>Iva=
n<br></div></div>

--000000000000a1be06062873c294--