Thread: [COMMITTERS] pgsql: Move autogenerated array types out of the way during ALTER ...R

Move autogenerated array types out of the way during ALTER ... RENAME.

Commit 9aa3c782c added code to allow CREATE TABLE/CREATE TYPE to not fail
when the desired type name conflicts with an autogenerated array type, by
dint of renaming the array type out of the way.  But I (tgl) overlooked
that the same case arises in ALTER TABLE/TYPE RENAME.  Fix that too.
Back-patch to all supported branches.

Report and patch by Vik Fearing, modified a bit by me

Discussion: https://postgr.es/m/0f4ade49-4f0b-a9a3-c120-7589f01d1eb8@2ndquadrant.com

Branch
------
REL9_6_STABLE

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

Modified Files
--------------
src/backend/catalog/pg_type.c             | 38 ++++++++++++++++++------
src/test/regress/expected/alter_table.out | 49 +++++++++++++++++++++++++++++++
src/test/regress/sql/alter_table.sql      | 20 +++++++++++++
3 files changed, 98 insertions(+), 9 deletions(-)