Re: [bug fix] ALTER TABLE SET LOGGED/UNLOGGED on a partitioned table does nothing silently

Поиск
Список
Период
Сортировка
Искать
От
Michael Paquier
Тема
Re: [bug fix] ALTER TABLE SET LOGGED/UNLOGGED on a partitioned table does nothing silently
Дата
Msg-id
X+WS0Zksc7YxPNpd@paquier.xyz
Ответ на
Список
Дерево обсуждения
[bug fix] ALTER TABLE SET LOGGED/UNLOGGED on a partitioned table does nothing silently "tsunakawa.takay@fujitsu.com" <tsunakawa.takay@fujitsu.com>
Re: [bug fix] ALTER TABLE SET LOGGED/UNLOGGED on a partitioned table does nothing silently Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Re: [bug fix] ALTER TABLE SET LOGGED/UNLOGGED on a partitioned table does nothing silently Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
RE: [bug fix] ALTER TABLE SET LOGGED/UNLOGGED on a partitioned table does nothing silently "tsunakawa.takay@fujitsu.com" <tsunakawa.takay@fujitsu.com>
Re: [bug fix] ALTER TABLE SET LOGGED/UNLOGGED on a partitioned table does nothing silently Alvaro Herrera <alvherre@alvh.no-ip.org>
RE: [bug fix] ALTER TABLE SET LOGGED/UNLOGGED on a partitioned table does nothing silently "tsunakawa.takay@fujitsu.com" <tsunakawa.takay@fujitsu.com>
Re: [bug fix] ALTER TABLE SET LOGGED/UNLOGGED on a partitioned table does nothing silently Alvaro Herrera <alvherre@alvh.no-ip.org>
RE: [bug fix] ALTER TABLE SET LOGGED/UNLOGGED on a partitioned table does nothing silently "tsunakawa.takay@fujitsu.com" <tsunakawa.takay@fujitsu.com>
Re: [bug fix] ALTER TABLE SET LOGGED/UNLOGGED on a partitioned table does nothing silently Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: [bug fix] ALTER TABLE SET LOGGED/UNLOGGED on a partitioned table does nothing silently Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Re: [bug fix] ALTER TABLE SET LOGGED/UNLOGGED on a partitioned table does nothing silently Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: [bug fix] ALTER TABLE SET LOGGED/UNLOGGED on a partitioned table does nothing silently Michael Paquier <michael@paquier.xyz>
RE: [bug fix] ALTER TABLE SET LOGGED/UNLOGGED on a partitioned table does nothing silently "tsunakawa.takay@fujitsu.com" <tsunakawa.takay@fujitsu.com>
RE: [bug fix] ALTER TABLE SET LOGGED/UNLOGGED on a partitioned table does nothing silently "tsunakawa.takay@fujitsu.com" <tsunakawa.takay@fujitsu.com>
Re: [bug fix] ALTER TABLE SET LOGGED/UNLOGGED on a partitioned table does nothing silently Michael Paquier <michael@paquier.xyz>
RE: [bug fix] ALTER TABLE SET LOGGED/UNLOGGED on a partitioned table does nothing silently "tsunakawa.takay@fujitsu.com" <tsunakawa.takay@fujitsu.com>
Re: [bug fix] ALTER TABLE SET LOGGED/UNLOGGED on a partitioned table does nothing silently Kyotaro Horiguchi <horikyota.ntt@gmail.com>
RE: [bug fix] ALTER TABLE SET LOGGED/UNLOGGED on a partitioned table does nothing silently "tsunakawa.takay@fujitsu.com" <tsunakawa.takay@fujitsu.com>
Re: [bug fix] ALTER TABLE SET LOGGED/UNLOGGED on a partitioned table does nothing silently Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: [bug fix] ALTER TABLE SET LOGGED/UNLOGGED on a partitioned table does nothing silently David Steele <david@pgmasters.net>
Re: [bug fix] ALTER TABLE SET LOGGED/UNLOGGED on a partitioned table does nothing silently Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
RE: [bug fix] ALTER TABLE SET LOGGED/UNLOGGED on a partitioned table does nothing silently "tsunakawa.takay@fujitsu.com" <tsunakawa.takay@fujitsu.com>
Re: [bug fix] ALTER TABLE SET LOGGED/UNLOGGED on a partitioned table does nothing silently Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Re: [bug fix] ALTER TABLE SET LOGGED/UNLOGGED on a partitioned table does nothing silently Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
RE: [bug fix] ALTER TABLE SET LOGGED/UNLOGGED on a partitioned table does nothing silently "tsunakawa.takay@fujitsu.com" <tsunakawa.takay@fujitsu.com>
Re: [bug fix] ALTER TABLE SET LOGGED/UNLOGGED on a partitioned table does nothing silently Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
RE: [bug fix] ALTER TABLE SET LOGGED/UNLOGGED on a partitioned table does nothing silently "tsunakawa.takay@fujitsu.com" <tsunakawa.takay@fujitsu.com>
On Wed, Dec 09, 2020 at 09:52:17AM -0300, Alvaro Herrera wrote:
> On 2020-Dec-09, tsunakawa.takay@fujitsu.com wrote:
>> The new partition will have a property specified when the user creates
>> it.  That is, while the storage property of each storage unit
>> (=partition) is basically independent, ALTER TABLE on a partitioned
>> table is a convenient way to set the same property value to all its
>> underlying storage units.
> 
> Well, that definition seems unfriendly to me.  I prefer the stance that
> if you change the value for the parent, then future partitions inherit
> that value.

That's indeed more interesting from the user perspective.  So +1 from
me.
--
Michael
В списке pgsql-hackers по дате отправления
От: Michael Paquier
Дата:
От: Michael Paquier
Дата:
FAQ