BTW, another issue this brings up is whether we should reject
regression=# create type footyp as (f2 int);
CREATE TYPE
regression=# alter table footyp rename to foobar;
ALTER TABLE
Currently, since there's no ALTER TYPE RENAME command, this is useful
functionality and I wouldn't want to forbid it. But if we provide
ALTER TYPE RENAME then consistency would suggest requiring people to
use that for composite types.
regards, tom lane