Re: COPY does not work with regproc and aclitem

Andrew Dunstan <andrew(at)dunslane(dot)net> writes:
> Zdenek Kotala wrote:
>> I'm not sure if it is important, but I think that preserve OID is
>> important and SQL level does not allow set OID.

> Does it matter in any case other than where it refers to an on-disk
> object? And does that need anything other than a fixup to
> pg_class::relfilenode?

The only things pg_upgrade should be trying to preserve OIDs for are
large objects. I don't even see a need to worry about relfilenode:
you've got to link the physical files into the new directory tree
anyway, you can perfectly well link them in under whatever new
relfilenode identity happens to be assigned during the dump-reload step.

This was all worked out years ago.

regards, tom lane