On 5/17/25 7:58 PM, Regina Obe wrote:
> Yah that is why I was suggesting as a switch not a default option. I think the default option works fine in most
cases.
> But I was thinking does pg_upgrade rely at all on OIDs? I guess that might make this not doable. I wasn't sure if
thatis part of the reason why it has to use
> the objects of the extension as they existed in the db.
It relies on OIDs which actually does make this a non-starter. Array
types for example include the type's OID in the data. So I cannot see
how this even can be made work without possibly tons of ugly hacks.
pg_upgrade does enough clever hacks.
Andreas
