On Sun, Feb 8, 2026 at 7:50 PM Álvaro Herrera <[email protected]> wrote: > > On 2026-02-08, Shinya Kato wrote: > > > Since pg_current_xact_id() returns xid8 which does not support > > arithmetic operators, places that need "xid + 1" cast the result via > > ::text::bigint first. > > I think it may be better to add some operators, or was there a rationale for > these not being there?
Thank you for your comment! I don't have a strong opinion on this, but according to [0], xid8 was intentionally designed not to support arithmetic. [0] https://www.postgresql.org/message-id/CA%2BhUKGL0TKUm3g8dywe6zVeSJLkaRYet1CgXMsB%2BF3bXJRJHFA%40mail.gmail.com -- Best regards, Shinya Kato NTT OSS Center
