Re: pg_upgrade and materialized views

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: pg_upgrade and materialized views
Дата
Msg-id 1AA7ED45-0DE1-481E-B174-602121425F53@anarazel.de
обсуждение исходный текст
Ответ на Re: pg_upgrade and materialized views  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: pg_upgrade and materialized views  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs

On February 20, 2018 3:44:47 PM PST, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>Anyway, I'm thinking the core of the problem here is that we've got
>multiple places that know which relkinds are physically transferred
>during a pg_upgrade, and they don't all know the same thing.  We
>need to centralize that knowledge somehow, or we're going to be
>singing this same tune again in the future.  Not quite sure where
>to put it though.  pg_dump and pg_upgrade both need to know that,
>but the backend doesn't, so I don't quite want to add it in
>pg_class.h where the core list of relkinds is.

Why do we need any relkind checks here at all? Shouldn't we just transport all xid horizons that are set before into
thenew cluster without filtering? 

And update all preexisting objects that have an xid set to the new the old cluster's nextxid?

Andres

--
Sent from my Android device with K-9 Mail. Please excuse my brevity.


В списке pgsql-bugs по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: pg_upgrade and materialized views
Следующее
От: Claudio Freire
Дата:
Сообщение: Re: pg_upgrade and materialized views