Horton

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

Tom Lane <tgl@sss.pgh.pa.us>

View on postgr.es
Commit: 94aced8cd0e229670877fe5c406a98d9a4f1b92a
Author: Tom Lane <tgl@sss.pgh.pa.us>
Date: 2017-05-26T19:16:59Z
Releases: 10.0 
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

Files

PathChange+/−
src/backend/catalog/pg_type.c modified +29 −9
src/test/regress/expected/alter_table.out modified +49 −0
src/test/regress/sql/alter_table.sql modified +20 −0

Discussion