Re: Virtual generated columns
От | Alexander Lakhin |
---|---|
Тема | Re: Virtual generated columns |
Дата | |
Msg-id | b5f96b24-ccac-47fd-9e20-14681b894f36@gmail.com обсуждение исходный текст |
Ответ на | Re: Virtual generated columns (Richard Guo <guofenglinux@gmail.com>) |
Ответы |
Re: Virtual generated columns
|
Список | pgsql-hackers |
Hello Richard,
22.02.2025 16:55, Richard Guo wrote:
22.02.2025 16:55, Richard Guo wrote:
create table t (a int, b int); create table vt (a int, b int generated always as (a * 2)); insert into t values (1, 1); insert into vt values (1); # select 1 from t t1 where exists (select 1 from vt where exists (select t1.a from t t2 where vt.b = 2)); ERROR: unexpected virtual generated column reference
I've discovered yet another way to trigger that error:
create table vt (a int, b int generated always as (a * 2), c int);
insert into vt values(1);
alter table vt alter column c type bigint using b + c;
ERROR: XX000: unexpected virtual generated column reference
LOCATION: CheckVarSlotCompatibility, execExprInterp.c:2410
Shouldn't this be expected/supported?
Best regards,
Alexander Lakhin
Neon (https://neon.tech)
В списке pgsql-hackers по дате отправления: