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

Поиск
Список
Период
Сортировка
От tsunakawa.takay@fujitsu.com
Тема RE: [bug fix] ALTER TABLE SET LOGGED/UNLOGGED on a partitioned table does nothing silently
Дата
Msg-id TYAPR01MB2990BFBF8172C18627E55A88FECC0@TYAPR01MB2990.jpnprd01.prod.outlook.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  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Список pgsql-hackers
From: Alvaro Herrera <alvherre@alvh.no-ip.org>
> But what happens when you create another partition after you change the
> "loggedness" of the partitioned table?

The new partition will have a property specified when the user creates it.  That is, while the storage property of each
storageunit (=partition) is basically independent, ALTER TABLE on a partitioned table is a convenient way to set the
sameproperty value to all its underlying storage units. 


> Well, my main take from that is we should strive to change all
> subcommands together, in some principled way, rather than change only
> one or some, in arbitrary ways.

I got an impression from the discussion that some form of consensus on the principle was made and you were trying to
createa fix for REPLICA IDENTITY.  Do you think the principle was unclear and we should state it first (partly to
refreshpeople's memories)? 

I'm kind of for it, but I'm hesitant to create the fix for all ALTER actions, because it may take a lot of time and
energyas you were afraid.  Can we define the principle, and then create individual fixes independently based on that
principle?


Regards
Takayuki Tsunakawa




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

Предыдущее
От:
Дата:
Сообщение: [PATCH] Feature improvement for CLOSE, FETCH, MOVE tab completion
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: small cleanup in unicode_norm.c