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

Поиск
Список
Период
Сортировка
От Richard Yen
Тема Re: BUG #15807: pg_upgrade does not account for renaming of systemcatalog column names
Дата
Msg-id CAKH4vDjx58ja=afr4cDO8VpwC=3PQ+m_PdNk=nnOyNLuae7wsw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: BUG #15807: pg_upgrade does not account for renaming of system catalog column names  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
Дерево обсуждения
Ok, thanks for the clarification!

--Richard

On Wed, May 15, 2019 at 11:39 AM Tom Lane <tgl@sss.pgh.pa.us> wrote:
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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: BUG #15807: pg_upgrade does not account for renaming of system catalog column names
Следующее
От: Daniel Gustafsson
Дата:
Сообщение: Re: BUG #15805: Problem with lower function for greek sigma (Σ) letter