Stephen Frost <sfrost@xxxxxxxxxxx> writes: > * Vik Fearing (vik.fearing@xxxxxxxxxxxxxxx) wrote: >> We generally discourage updating the catalogs directly. This was why I >> wrote the CREATE/ALTER DATABASE patch in 2014 that you helped me with >> (fbb1d7d73f8). >> I'm willing to work on a patch for ALTER TYPE if it has a chance of >> being accepted. > Seems pretty clear that it'd be a useful thing to have, so +1 from me, > at least. We'd have to be extremely circumspect about what aspects of a base type could be altered after-the-fact. Adding binary I/O functions seems unproblematic, but I'm not very sure what else is. regards, tom lane