vignesh C <vignesh21(at)gmail(dot)com> writes:
> Recently we have supported upgrade of subscriptions,but currently
> subscription OIDs can be changed when a cluster is upgraded using
> pg_upgrade. It will be better to preserve them as it will be easier to
> compare subscription related objects in pg_subscription and
> pg_subscription_rel in the old and new clusters.
I do not think that's a sufficient argument. For other object types,
we only go through these pushups if we *have to* do so because the
OIDs may appear in user tables or file names. I don't see a reason
that subscriptions deserve special treatment.
regards, tom lane