100.179370@germanynet.de (Martin Jacobs) writes:
> If you don't need type 'name' do
> DROP TYPE name;
This would be an exceedingly bad idea, since 'name' is used throughout
the system catalogs.
It might work to rename the type (eg, "update pg_type set typname =
'pgname' where typname = 'name'). Haven't tried that to see what
sorts of problems it might have. Would definitely recommend doing
any experimentation of this sort in a scratch database ;-)
regards, tom lane