pgsql: Update pg_upgrade test for reg* to include regrole and regnamesp

From: Andres Freund <andres(at)anarazel(dot)de>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Update pg_upgrade test for reg* to include regrole and regnamesp
Date: 2018-11-27 01:18:46
Message-ID: E1gRS1W-0007eo-RM@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Update pg_upgrade test for reg* to include regrole and regnamespace.

When the regrole (0c90f6769) and regnamespace (cb9fa802b) types were
added in 9.5, pg_upgrade's check for reg* types wasn't updated. While
regrole currently is safe, regnamespace is not.

It seems unlikely that anybody uses regnamespace inside catalog tables
across a pg_upgrade, but the tests should be correct nevertheless.

While at it, reorder the types checked in the query to be
alphabetical. Otherwise it's annoying to compare existing and tested
for types.

Author: Andres Freund
Discussion: https://postgr.es/m/037e152a-cb25-3bcb-4f35-bdc9988f8204@2ndQuadrant.com
Backpatch: 9.5-, as regrole/regnamespace

Branch
------
REL_11_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/203a909fd29656d65a451c791e326ff92a09d893

Modified Files
--------------
src/bin/pg_upgrade/check.c | 13 ++++++++-----
1 file changed, 8 insertions(+), 5 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Andres Freund 2018-11-27 01:18:48 pgsql: Update pg_upgrade test for reg* to include regrole and regnamesp
Previous Message Andres Freund 2018-11-27 01:18:45 pgsql: Update pg_upgrade test for reg* to include regrole and regnamesp