Re: ALTER TABLE support for dropping generation expression - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: ALTER TABLE support for dropping generation expression
Date
Msg-id 879ef3c3-3302-40b6-715a-b4cb32ba5660@2ndquadrant.com
Whole thread Raw
In response to Re: ALTER TABLE support for dropping generation expression  (Sergei Kornilov <sk@zsrv.org>)
Responses Re: ALTER TABLE support for dropping generation expression  (Sergei Kornilov <sk@zsrv.org>)
List pgsql-hackers
On 2019-12-25 12:01, Sergei Kornilov wrote:
> Patch does not apply to master. Could you rebase?

done

> I noticed one bug:
> 
> create table testdrop (i int, b int, m int GENERATED ALWAYS AS ( i*2) stored);
> insert into testdrop(i,b) values (3,4);
> alter table testdrop alter COLUMN m drop expression ;
> alter table testdrop drop column i;
> 
> Here is no "m" column anymore. Possible due some forgotten dependency?

fixed -- good catch

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Attachment

pgsql-hackers by date:

Previous
From: Vik Fearing
Date:
Subject: Greatest Common Divisor
Next
From: Vik Fearing
Date:
Subject: Recognizing superuser in pg_hba.conf