Re: alter table set TABLE ACCESS METHOD

Поиск
Список
Период
Сортировка
Искать
От
Jeff Davis
Тема
Re: alter table set TABLE ACCESS METHOD
Дата
Msg-id
d47f55de936b6808e5d5e3177b410d1e0909faa1.camel@j-davis.com
Ответ на
Список
Дерево обсуждения
Re: alter table set TABLE ACCESS METHOD Jeff Davis <pgsql@j-davis.com>
Re: alter table set TABLE ACCESS METHOD Justin Pryzby <pryzby@telsasoft.com>
Re: alter table set TABLE ACCESS METHOD Jeff Davis <pgsql@j-davis.com>
Re: alter table set TABLE ACCESS METHOD Jeff Davis <pgsql@j-davis.com>
Re: alter table set TABLE ACCESS METHOD Jeff Davis <pgsql@j-davis.com>
Re: alter table set TABLE ACCESS METHOD Michael Paquier <michael@paquier.xyz>
Re: alter table set TABLE ACCESS METHOD Justin Pryzby <pryzby@telsasoft.com>
Re: alter table set TABLE ACCESS METHOD Jeff Davis <pgsql@j-davis.com>
Re: alter table set TABLE ACCESS METHOD vignesh C <vignesh21@gmail.com>
Re: alter table set TABLE ACCESS METHOD Zhihong Yu <zyu@yugabyte.com>
Re: alter table set TABLE ACCESS METHOD Justin Pryzby <pryzby@telsasoft.com>
Re: alter table set TABLE ACCESS METHOD Michael Paquier <michael@paquier.xyz>
Re: alter table set TABLE ACCESS METHOD Michael Paquier <michael@paquier.xyz>
Re: alter table set TABLE ACCESS METHOD Jeff Davis <pgsql@j-davis.com>
Re: alter table set TABLE ACCESS METHOD Michael Paquier <michael@paquier.xyz>
Re: alter table set TABLE ACCESS METHOD Jeff Davis <pgsql@j-davis.com>
Re: alter table set TABLE ACCESS METHOD Michael Paquier <michael@paquier.xyz>
On Wed, 2021-06-09 at 13:47 +0900, Michael Paquier wrote:
> There is a mix of upper and lower-case characters here.  It could be
> more consistent.  It seems to me that this test should actually check
> that pg_class.relam reflects the new value.

Done. I also added a (negative) test for changing the AM of a
partitioned table, which wasn't caught before.

> +                errmsg("cannot have multiple SET ACCESS METHOD
> subcommands")));
> Worth adding a test?

Done.

> Nit: the name of the variable looks inconsistent with this comment.
> The original is weird as well.

Tried to improve wording.

> I am wondering if it would be a good idea to set the new tablespace
> and new access method fields to InvalidOid within
> ATGetQueueEntry.  We
> do that for the persistence.  Not critical at all, still..

Done.

> +           pass = AT_PASS_MISC;
> Maybe add a comment here?

Done. In that case, it doesn't matter because there's no work to be
done in Phase 2.

Regards,
	Jeff Davis

В списке pgsql-hackers по дате отправления
От: Tom Lane
Дата:
От: Jonathan S. Katz
Дата:
FAQ