On 30/10/2018 16:14, Sergei Kornilov wrote: > Hi > > I applied this patch on top 2fe42baf7c1ad96b5f9eb898161e258315298351 commit > and found a bug while adding STORED column: > > postgres=# create table test(i int); > CREATE TABLE > postgres=# insert into test values (1),(2); > INSERT 0 2 > postgres=# alter table test add column gen_stored integer GENERATED ALWAYS AS > ((i * 2)) STORED; > ALTER TABLE > postgres=# alter table test add column gen_virt integer GENERATED ALWAYS AS > ((i * 2)); > ALTER TABLE > postgres=# table test; > i | gen_stored | gen_virt > ---+------------+---------- > 1 | | 2 > 2 | | 4 > > Virtual columns was calculated on table read and its ok, but stored column > does not update table data.
This is a small bug that I will fix in my next update. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
