Re: Fix propagation of persistence to sequences in ALTER TABLE / ADD COLUMN

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: Fix propagation of persistence to sequences in ALTER TABLE / ADD COLUMN
Дата
Msg-id 7e0dcf16-60c4-4cf6-81b9-9e51b397a355@eisentraut.org
обсуждение исходный текст
Ответ на Re: Fix propagation of persistence to sequences in ALTER TABLE / ADD COLUMN  (Ashutosh Bapat <ashutosh.bapat.oss@gmail.com>)
Список pgsql-hackers
On 08.02.24 07:04, Ashutosh Bapat wrote:
> The patch looks ok.
> 
> +    seqstmt->sequence->relpersistence = cxt->rel ?
> cxt->rel->rd_rel->relpersistence : cxt->relation->relpersistence;
> +
> 
> This condition looks consistent with the other places in the code
> around line 435, 498.

Ah good, that pattern already existed.

> But I was worried that cxt->rel may not get
> latest relpersistence if the ALTER TABLE changes persistence as well.
> Added a test (0002) which shows that ctx->rel has up-to-date
> relpersistence. Also added a few other tests. Feel free to
> include/reject them while committing.

Yes, this additional coverage seems good.  Committed with your additions.




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

Предыдущее
От: "Zhijie Hou (Fujitsu)"
Дата:
Сообщение: RE: Synchronizing slots from primary to standby
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: Simplify documentation related to Windows builds