Re: [WIP] ALTER COLUMN IF EXISTS

2022-04-01 Thread Daniel Gustafsson
> On 1 Apr 2022, at 02:30, Tom Lane wrote: > "David G. Johnston" writes: >> At present the project seems to largely consider the IF EXISTS/IF NOT >> EXISTS features to have been largely a mistake and while removing it is not >> going to happen the desire to change or extend it is not strong. >

Re: [WIP] ALTER COLUMN IF EXISTS

2022-03-31 Thread Robert Haas
On Thu, Mar 31, 2022 at 8:02 PM David G. Johnston wrote: > At present the project seems to largely consider the IF EXISTS/IF NOT EXISTS > features to have been largely a mistake and while removing it is not going to > happen the desire to change or extend it is not strong. I like the IF [NOT] E

Re: [WIP] ALTER COLUMN IF EXISTS

2022-03-31 Thread Tom Lane
"David G. Johnston" writes: > On Thu, Mar 31, 2022 at 4:39 PM Bradley Ayers > wrote: >> I'm interested in adding more ergonomics to DDL commands, in >> particular supporting IF EXISTS for ALTER TABLE … ALTER COLUMN, so >> that if a column doesn't exist the command is skipped. > At present the pr

Re: [WIP] ALTER COLUMN IF EXISTS

2022-03-31 Thread David G. Johnston
On Thu, Mar 31, 2022 at 4:39 PM Bradley Ayers wrote: > > I'm interested in adding more ergonomics to DDL commands, in > particular supporting IF EXISTS for ALTER TABLE … ALTER COLUMN, so > that if a column doesn't exist the command is skipped. > > IF EXISTS is already supported in various places