Re: bug: ALTER TABLE ADD VIRTUAL GENERATED COLUMN with table rewrite

2025-03-04 Thread Peter Eisentraut
On 28.02.25 14:36, Srinath Reddy wrote: Hi, I have applied the patch and verified,and patch LGTM. committed, thanks

Re: bug: ALTER TABLE ADD VIRTUAL GENERATED COLUMN with table rewrite

2025-02-28 Thread Srinath Reddy
Hi, I have applied the patch and verified,and patch LGTM. Thanks and regards Srinath Reddy Sadipiralla EDB: https://www.enterprisedb.com/

bug: ALTER TABLE ADD VIRTUAL GENERATED COLUMN with table rewrite

2025-02-27 Thread jian he
hi. bug demo: CREATE TABLE gtest20a (a int PRIMARY KEY, b int GENERATED ALWAYS AS (a * 2) VIRTUAL); ALTER TABLE gtest20a ADD COLUMN c float8 DEFAULT RANDOM() CHECK (b < 60); ERROR: no generation expression found for column number 2 of table "pg_temp_17306" issue is that in ATRewriteTable(Altere