Hi, On 2018-10-09 16:17:44 -0700, Mark Dilger wrote: > > On Oct 9, 2018, at 12:22 PM, Andres Freund <and...@anarazel.de> wrote: > > As discussed below (at [1]), I think we should remove $subject. I plan > > to do so, unless somebody protests soon-ish. I thought it'd be better > > to call attention to this in a new thread, to make sure people had a > > chance to object. > > I have no objection, but I'm curious, when retiring a datatype and > associated functions, do the Oids that were assigned to them become > available for new uses, or do you have to expire them to avoid breaking > pg_upgrade and such? Retiring built-in types and functions seems > rare enough that I've not seen how this is handled before.
I don't really see a need for preserving them. pg_upgrade should fail because the schema dump won't restore (as that has textual oids). You could argue that external drivers could have the oids builtin, but I don't find that convincing, because they'd be in trouble for new types etc anyway. Greetings, Andres Freund
