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 that is 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
