Re: Add contrib/pg_logicalsnapinspect - Mailing list pgsql-hackers

From Bertrand Drouvot
Subject Re: Add contrib/pg_logicalsnapinspect
Date
Msg-id ZvRI4n+U466Mq6Q2@ip-10-97-1-34.eu-west-3.compute.internal
Whole thread Raw
In response to Re: Add contrib/pg_logicalsnapinspect  (shveta malik <shveta.malik@gmail.com>)
Responses Re: Add contrib/pg_logicalsnapinspect
List pgsql-hackers
Hi,

On Wed, Sep 25, 2024 at 11:23:17AM +0530, shveta malik wrote:
> + OUT catchange_xip xid[]
> 
> One question, what is xid datatype, is it too int8? Sorry, could not
> find the correct doc.

I think that we can get the answer from pg_type:

postgres=# select typname,typlen from pg_type where typname = 'xid';
 typname | typlen
---------+--------
 xid     |      4
(1 row)

> Since we are getting uint32 in Int64, this also needs to be accordingly.

I think the way it is currently done is fine: we're dealing with TransactionId
(and not with FullTransactionId). So, the Int64GetDatum() output would still
stay in the "xid" range. Keeping xid in the .sql makes it clear that we are
dealing with transaction ID.

Regards,

-- 
Bertrand Drouvot
PostgreSQL Contributors Team
RDS Open Source Databases
Amazon Web Services: https://aws.amazon.com



pgsql-hackers by date:

Previous
From: Nathan Bossart
Date:
Subject: Re: src/backend/optimizer/util/plancat.c -> Is this correct English
Next
From: "Daniel Westermann (DWE)"
Date:
Subject: Re: src/backend/optimizer/util/plancat.c -> Is this correct English