Re: Dumping/restoring fails on inherited generated column

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Dumping/restoring fails on inherited generated column
Дата
Msg-id 661371.1601398006@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Dumping/restoring fails on inherited generated column  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
I wrote:
> The situation is different for GENERATED columns, since we disallow
> a child having a different GENERATED property than the parent.

BTW, that alleged prohibition is pretty damn leaky:

d3=# create table pp1 (a int, b int GENERATED ALWAYS AS (a * 2) STORED);
CREATE TABLE
d3=# create table cc1 (a int, b int GENERATED ALWAYS AS (a * 3) STORED);
CREATE TABLE
d3=# alter table cc1 inherit pp1;
ALTER TABLE

Maybe the *real* fix here is to give up on this idea that they
can't be different?

            regards, tom lane



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