Re: longfin and tamandua aren't too happy but I'm not sure why - Mailing list pgsql-hackers

From Dilip Kumar
Subject Re: longfin and tamandua aren't too happy but I'm not sure why
Date
Msg-id CAFiTN-tJqU-e2r1Q2sS65TacA-Yorgzhy1cgukaCwu1v2SSm3A@mail.gmail.com
Whole thread Raw
In response to Re: longfin and tamandua aren't too happy but I'm not sure why  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: longfin and tamandua aren't too happy but I'm not sure why
Re: longfin and tamandua aren't too happy but I'm not sure why
List pgsql-hackers
On Wed, Sep 28, 2022 at 2:59 AM Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
> ... also, lapwing's not too happy [1].  The alter_table test
> expects this to yield zero rows, but it doesn't:

By looking at regression diff as shown below, it seems that we are
able to get the relfilenode from the Oid using
pg_relation_filenode(oid) but the reverse mapping
pg_filenode_relation(reltablespace, relfilenode) returned NULL.

I am not sure but by looking at the code it is somehow related to
alignment padding while computing the hash key size in the 32-bit
machine in the function InitializeRelfilenumberMap().  I am still
looking into this and will provide updates on this.

+  oid  | mapped_oid | reltablespace | relfilenode |
 relname
+-------+------------+---------------+-------------+------------------------------------------------
+ 16385 |            |             0 |      100000 | char_tbl
+ 16388 |            |             0 |      100001 | float8_tbl
+ 16391 |            |             0 |      100002 | int2_tbl
+ 16394 |            |             0 |      100003 | int4_tbl


--
Regards,
Dilip Kumar
EnterpriseDB: http://www.enterprisedb.com



pgsql-hackers by date:

Previous
From: Kyotaro Horiguchi
Date:
Subject: Re: Refactor backup related code (was: Is it correct to say, "invalid data in file \"%s\"", BACKUP_LABEL_FILE in do_pg_backup_stop?)
Next
From: Peter Smith
Date:
Subject: Re: Fix some newly modified tab-complete changes