Thread: pgsql: Allow ALTER TYPE to update an existing type's typsubscript value

pgsql: Allow ALTER TYPE to update an existing type's typsubscript value

From
Tom Lane
Date:
Allow ALTER TYPE to update an existing type's typsubscript value.

This is essential if we'd like to allow existing extension data types
to support subscripting in future, since dropping and recreating the
type isn't a practical thing for an extension upgrade script, and
direct manipulation of pg_type isn't a great answer either.

There was some discussion about also allowing alteration of typelem,
but it's less clear whether that's a good idea or not, so for now
I forebore.

Discussion: https://postgr.es/m/3724341.1607551174@sss.pgh.pa.us

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/8c15a297452e970d68529ee2ce6bd94d84598409

Modified Files
--------------
doc/src/sgml/ref/alter_type.sgml          |  8 +++++++
src/backend/commands/typecmds.c           | 20 +++++++++++++++++
src/test/regress/expected/create_type.out | 36 ++++++++++++++++---------------
src/test/regress/sql/create_type.sql      | 12 ++++++-----
4 files changed, 54 insertions(+), 22 deletions(-)