Re: ALTER TABLE support for dropping generation expression

2020-01-14 Thread Peter Eisentraut
On 2020-01-13 10:56, Sergei Kornilov wrote: The following review has been posted through the commitfest application: make installcheck-world: tested, passed Implements feature: tested, passed Spec compliant: not tested Documentation:tested, passed Thank you! Looks go

Re: ALTER TABLE support for dropping generation expression

2020-01-13 Thread Sergei Kornilov
The following review has been posted through the commitfest application: make installcheck-world: tested, passed Implements feature: tested, passed Spec compliant: not tested Documentation:tested, passed Thank you! Looks good to me. I have no further comments. I'll mar

Re: ALTER TABLE support for dropping generation expression

2020-01-10 Thread Peter Eisentraut
On 2020-01-10 13:20, Sergei Kornilov wrote: Thank you, but I am late: patch has another merge conflict. Conflict seems trivial and patch looks fine for me. Here is another patch version. I have resolved the conflict and also added a check that you don't drop the generation expression from an

Re: ALTER TABLE support for dropping generation expression

2020-01-10 Thread Sergei Kornilov
Hello Thank you, but I am late: patch has another merge conflict. Conflict seems trivial and patch looks fine for me. regards, Sergei

Re: ALTER TABLE support for dropping generation expression

2019-12-28 Thread Peter Eisentraut
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 ; a

Re: ALTER TABLE support for dropping generation expression

2019-12-25 Thread Sergei Kornilov
The following review has been posted through the commitfest application: make installcheck-world: not tested Implements feature: tested, failed Spec compliant: not tested Documentation:tested, passed Hello Patch does not apply to master. Could you rebase? Code looks

ALTER TABLE support for dropping generation expression

2019-12-08 Thread Peter Eisentraut
A small add-on to the generated columns feature: Add an ALTER TABLE subcommand for dropping the generated property from a column, per SQL standard. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services From 8aa4710e1f