pgsql: Allow ALTER TYPE to update an existing type's typsubscript value
pgsql: Allow ALTER TYPE to update an existing type's typsubscript value
От:
Tom Lane <tgl@sss.pgh.pa.us>
Дата:
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(-)