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 (Michael Paquier)
Список
Дерево обсуждения
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 по дате отправления