pgsql: Allow ALTER TYPE to update an existing type's typsubscript value - Mailing list pgsql-committers

From Tom Lane
Subject pgsql: Allow ALTER TYPE to update an existing type's typsubscript value
Date
Msg-id E1knsJ5-0005O8-4j@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
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(-)


pgsql-committers by date:

Previous
From: Peter Eisentraut
Date:
Subject: pgsql: pg_dump: Don't use enums for defining bit mask values
Next
From: Bruce Momjian
Date:
Subject: pgsql: initdb: properly alphabetize getopt_long options in C string