BUG #15807: pg_upgrade does not account for renaming of system catalog column names

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

BUG #15807: pg_upgrade does not account for renaming of system catalog column names

apt.postgresql.org Repository Update
The following bug has been logged on the website:

Bug reference:      15807
Logged by:          Richard Yen
Email address:      [hidden email]
PostgreSQL version: 10.8
Operating system:   CentOS 6
Description:        

example: pg_stat_replication.sent_location was renamed to
pg_stat_replication.sent_lsn in v10.  If a view in 9.6 refers to
pg_stat_replication.sent_location, pg_upgrade fails entirely because "column
pg_stat_replication.sent_location does not exist"

Reply | Threaded
Open this post in threaded view
|

Re: BUG #15807: pg_upgrade does not account for renaming of system catalog column names

Tom Lane-2
PG Bug reporting form <[hidden email]> writes:
> example: pg_stat_replication.sent_location was renamed to
> pg_stat_replication.sent_lsn in v10.

Yeah, that's a documented compatibility issue, per the v10 notes:

  * Rename WAL-related functions and views to use lsn instead of location
    (David Rowley)

> If a view in 9.6 refers to
> pg_stat_replication.sent_location, pg_upgrade fails entirely because "column
> pg_stat_replication.sent_location does not exist"

It is not pg_upgrade's job to fix such things.  Sorry.

                        regards, tom lane


Reply | Threaded
Open this post in threaded view
|

Re: BUG #15807: pg_upgrade does not account for renaming of system catalog column names

richyen3@gmail.com
Ok, thanks for the clarification!

--Richard

On Wed, May 15, 2019 at 11:39 AM Tom Lane <[hidden email]> wrote:
PG Bug reporting form <[hidden email]> writes:
> example: pg_stat_replication.sent_location was renamed to
> pg_stat_replication.sent_lsn in v10.

Yeah, that's a documented compatibility issue, per the v10 notes:

  * Rename WAL-related functions and views to use lsn instead of location
    (David Rowley)

> If a view in 9.6 refers to
> pg_stat_replication.sent_location, pg_upgrade fails entirely because "column
> pg_stat_replication.sent_location does not exist"

It is not pg_upgrade's job to fix such things.  Sorry.

                        regards, tom lane