Horton

Re: ALTER TABLE support for dropping generation expression

Peter Eisentraut <peter.eisentraut@2ndquadrant.com>

View thread View on postgr.es
From: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
To: Sergei Kornilov <sk@zsrv.org>, pgsql-hackers@lists.postgresql.org
Date: 2019-12-28T17:05:28Z
Lists: pgsql-hackers

Attachments

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

Commits

  1. ALTER TABLE ... ALTER COLUMN ... DROP EXPRESSION