Re: pg_upgrade ability to create extension from scripts

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