From: | Michael Paquier <michael(at)paquier(dot)xyz> |
---|---|
To: | jian he <jian(dot)universality(at)gmail(dot)com> |
Cc: | PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
Subject: | Re: maybe a type_sanity. sql bug |
Date: | 2023-10-27 05:10:54 |
Message-ID: | ZTtGXvmf9yKNuZro@paquier.xyz |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Paquier | 2023-10-27 05:13:49 | Re: [PoC] pg_upgrade: allow to upgrade publisher node |
Previous Message | Michael Paquier | 2023-10-27 05:02:48 | Re: Introduce a new view for checkpointer related stats |