pgsql: Fix inconsistencies for queries on pg_class in type_sanity.sql

From: Michael Paquier <michael(at)paquier(dot)xyz>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Fix inconsistencies for queries on pg_class in type_sanity.sql
Date: 2023-11-12 01:07:09
Message-ID: E1r1ywO-0050Xa-WA@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Fix inconsistencies for queries on pg_class in type_sanity.sql

Three queries did not consider partitioned indexes and tables, and
surrounding comments have not been updated in a while.

Like 4b9fbd6be442, this is only cosmetic currently as no such relkinds
exist at this stage of the regression tests, but running these queries
on existing clusters could lead to incorrect results.

Author: Jian He, Michael Paquier
Discussion: https://postgr.es/m/CACJufxGsB1ciahkNDccyxhw-Pfp_-_y+Wx+1BOdRyVVxKojAbg@mail.gmail.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/a9f19c1349c22819038842a0debba2c86b4832b8

Modified Files
--------------
src/test/regress/expected/type_sanity.out | 14 ++++++++------
src/test/regress/sql/type_sanity.sql | 14 ++++++++------
2 files changed, 16 insertions(+), 12 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Michael Paquier 2023-11-12 07:44:27 pgsql: Add ability to reset all shared stats types in pg_stat_reset_sha
Previous Message Michael Paquier 2023-11-12 00:22:20 Re: pgsql: Don't trust unvalidated xl_tot_len.