> 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.
>
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
"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
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
Hi,
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 (e.g. ALTER TABLE …
ADD COLUMN IF NOT EXISTS, and ALTER TABLE