> > Yes. Before doing this change, it is better to confirm the approach and > then do all the changes. > > 1. Does everyone agrees that renaming the existing datatype without > changing the OID? >
As I said before, Npgsql for one loads data types by name, not by OID. So this would definitely cause breakage. For users who actually need the new variable-length type, it seems perfectly reasonable to ask to switch to a new type - after all they're making a change in their system. It would really be preferable to leave the current type alone and create a new one.