For the next review cycle, here is a patch that adds some ALTER TYPE
subcommands for composite types:
ALTER TYPE ... ADD ATTRIBUTE
ALTER TYPE ... DROP ATTRIBUTE
ALTER TYPE ... ALTER ATTRIBUTE ... SET DATA TYPE
ALTER TYPE ... RENAME ATTRIBUTE
These work similarly to the analogous ALTER TABLE / $ACTION COLUMN
commands. The first two above are from the SQL standard.