Re: BUG #19698: IMPORT FOREIGN SCHEMA treats a NOT VALID NOT NULL constraint as validated

From: Etsuro Fujita <etsuro(dot)fujita(at)gmail(dot)com>
To: Andrey Borodin <x4mmm(at)yandex-team(dot)ru>
Cc: Kirill Reshke <reshkekirill(at)gmail(dot)com>, imchifan(at)163(dot)com, PostgreSQL mailing lists <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: BUG #19698: IMPORT FOREIGN SCHEMA treats a NOT VALID NOT NULL constraint as validated
Date: 2026-10-07 05:00:41
Message-ID: CAPmGK14z10JUh6seiDzksvjZLdh3-PMyk=fhxFwaF_AMszG9ag@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Mon, Sep 21, 2026 at 7:18 PM Andrey Borodin <x4mmm(at)yandex-team(dot)ru> wrote:
> On 18 Sep 2026, Kirill Reshke wrote:
> > One simple fix can be simply importing NOT NULL NOT VALID as a
> > nullable column, but this probably would make some people unhappy.
>
> I support the simpler fix.

I don't think this is a bug. See [1].

Best regards,
Etsuro Fujita

[1] https://www.postgresql.org/message-id/CAPmGK15wJxr-TZ9gvptw%2BrCw12RoESt_HVFZhLFc1_P4k50dkQ%40mail.gmail.com

In response to

Browse pgsql-bugs by date

  From Date Subject
Previous Message Etsuro Fujita 2026-10-07 04:52:51 Re: BUG #19698: IMPORT FOREIGN SCHEMA treats a NOT VALID NOT NULL constraint as validated