Re: Bug with "CHECK" when part of ALTER TABLE ... ADD COLUMN IF NOT EXISTS ... CHECK ...

Thanks for the quick response! Do you have any suggestion on work arounds?

On Tue, Sep 24, 2019 at 1:31 PM Fabrízio de Royes Mello <
fabriziomello(at)gmail(dot)com> wrote:

>
> On Tue, Sep 24, 2019 at 5:27 PM Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> >
> > "Alfred R. Fuller" <alfred(dot)fuller(at)gmail(dot)com> writes:
> > > Expected behavior:
> > > If the column exists nothing is altered.
> > > Actual behavior:
> > > The check is always added regardless if the column exists or not.
> >
> > Yeah, this is yet another variant of the theme that ADD COLUMN IF EXISTS
> > only conditionalizes the creation of the column proper, and not other
> > subsidiary subcommands such as adding indexes or constraints. I've been
> > poking at a fix [1], and hopefully we'll get it dealt with in v13, but
> > for sure it'll be a bigger change than we'd risk back-patching.
> >
>
> Nice... I didn't see it... thanks
>
> --
> Fabrízio de Royes Mello Timbira - http://www.timbira.com.br/
> PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento
>