Re: ATTACH PARTITION seems to ignore column generation status

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: ATTACH PARTITION seems to ignore column generation status
Дата
Msg-id 20230216180542.fdy5fnwkcbnhen6m@alvherre.pgsql
обсуждение исходный текст
Ответ на Re: ATTACH PARTITION seems to ignore column generation status  (Alexander Lakhin <exclusion@gmail.com>)
Ответы Re: ATTACH PARTITION seems to ignore column generation status  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
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.

-- 
Álvaro Herrera               48°01'N 7°57'E  —  https://www.EnterpriseDB.com/
"Pido que me den el Nobel por razones humanitarias" (Nicanor Parra)



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

Предыдущее
От: Pavel Luzanov
Дата:
Сообщение: Re: psql: Add role's membership options to the \du+ command
Следующее
От: Bharath Rupireddy
Дата:
Сообщение: Add WAL read stats to pg_stat_wal