Re: ATTACH PARTITION seems to ignore column generation status

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: ATTACH PARTITION seems to ignore column generation status
Дата
Msg-id 2334335.1676587222@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: ATTACH PARTITION seems to ignore column generation status  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Список pgsql-hackers
Alvaro Herrera <alvherre@alvh.no-ip.org> writes:
> On 2023-Feb-16, Alexander Lakhin wrote:
>> I've encountered a query that triggers an assert added in that commit:
>> CREATE TABLE t(a int, b int GENERATED ALWAYS AS (a) STORED) PARTITION BY
>> RANGE (a);
>> CREATE TABLE tp PARTITION OF t(b DEFAULT 1) FOR VALUES FROM (0) to (1);

> It seems wrong that this command is accepted.  It should have given an
> error, because the partition is not allowed to override the generation
> of the value that is specified in the parent table.

Agreed.  We missed a check somewhere, will fix.

            regards, tom lane



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

Предыдущее
От: David Rowley
Дата:
Сообщение: Introduce list_reverse() to make lcons() usage less inefficient
Следующее
От: Andrey Borodin
Дата:
Сообщение: psql \watch 2nd argument: iteration count