Re: Pro et contra of preserving pg_proc oids during pg_upgrade

Then what does it matter whether you spell it:

12345

or

my_ext.do_something(int)

?

Why do you require us to redefine the scope for which pg_proc.oid is useful in order to implement this behavior?

Your extension breaks if your user uses logical backups or we otherwise get into a position where pg_upgrade cannot be used to migrate in the future.  Is avoiding the textual representation so necessary that you need to add another dependency to the system?  That just seems unwise regardless of how easy it may be to accomplish.

David J.