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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: richyen3(at)gmail(dot)com
Cc: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #15807: pg_upgrade does not account for renaming of system catalog column names
Date: 2019-05-15 18:39:07
Message-ID: 17248.1557945547@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

PG Bug reporting form <noreply(at)postgresql(dot)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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Richard Yen 2019-05-15 18:44:06 Re: BUG #15807: pg_upgrade does not account for renaming of system catalog column names
Previous Message PG Bug reporting form 2019-05-15 18:06:34 BUG #15807: pg_upgrade does not account for renaming of system catalog column names