Re: Preserve subscription OIDs during pg_upgrade - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Preserve subscription OIDs during pg_upgrade
Date
Msg-id 1502971.1708878875@sss.pgh.pa.us
Whole thread Raw
In response to Preserve subscription OIDs during pg_upgrade  (vignesh C <vignesh21@gmail.com>)
Responses Re: Preserve subscription OIDs during pg_upgrade
List pgsql-hackers
vignesh C <vignesh21@gmail.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



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Optimize planner memory consumption for huge arrays
Next
From: Tom Lane
Date:
Subject: Re: libpq: PQfnumber overload for not null-terminated strings