On Fri, Oct 27, 2023 at 11:45:44AM +0800, jian he wrote: > The test seems to assume the following sql query should return zero row. > but it does not. I don't know much about the "relreplident" column.
This is not about relreplident here, that refers to a relation's replica identity. > test1=# SELECT c1.oid, c1.relname, relkind, relpersistence, relreplident > FROM pg_class as c1 > WHERE relkind NOT IN ('r', 'i', 'S', 't', 'v', 'm', 'c', 'f', 'p') OR > relpersistence NOT IN ('p', 'u', 't') OR > relreplident NOT IN ('d', 'n', 'f', 'i'); > oid | relname | relkind | relpersistence | relreplident > -----+---------+---------+----------------+-------------- > (0 rows) The problem is about relkind, as 'I' refers to a partitioned index. That is a legal value in pg_class.relkind, but we forgot to list it in this test. -- Michael
signature.asc
Description: PGP signature