Re: BUG #15807: pg_upgrade does not account for renaming of system catalog column names - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #15807: pg_upgrade does not account for renaming of system catalog column names
Date
Msg-id 17248.1557945547@sss.pgh.pa.us
Whole thread Raw
In response to BUG #15807: pg_upgrade does not account for renaming of system catalog column names  (PG Bug reporting form <noreply@postgresql.org>)
Responses Re: BUG #15807: pg_upgrade does not account for renaming of systemcatalog column names  (Richard Yen <richyen3@gmail.com>)
List pgsql-bugs
PG Bug reporting form <noreply@postgresql.org> 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



pgsql-bugs by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #15807: pg_upgrade does not account for renaming of system catalog column names
Next
From: Richard Yen
Date:
Subject: Re: BUG #15807: pg_upgrade does not account for renaming of systemcatalog column names