Request a Demo
Home   >   mailing lists

Re: BUG #19698: IMPORT FOREIGN SCHEMA treats a NOT VALID NOT NULL constraint as validated - Mailing list pgsql-bugs

From Etsuro Fujita
Subject Re: BUG #19698: IMPORT FOREIGN SCHEMA treats a NOT VALID NOT NULL constraint as validated
Date
Msg-id CAPmGK14z10JUh6seiDzksvjZLdh3-PMyk=fhxFwaF_AMszG9ag@mail.gmail.com
Whole thread
In response to Re: BUG #19698: IMPORT FOREIGN SCHEMA treats a NOT VALID NOT NULL constraint as validated  (Andrey Borodin <x4mmm@yandex-team.ru>)
List pgsql-bugs
Tree view 
On Mon, Sep 21, 2026 at 7:18 PM Andrey Borodin <x4mmm@yandex-team.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

pgsql-bugs by date:

Previous
From: Etsuro Fujita
Date:
Subject: Re: BUG #19698: IMPORT FOREIGN SCHEMA treats a NOT VALID NOT NULL constraint as validated
Next
From: Laurenz Albe
Date:
Subject: Re: BUG #19747: pg_dump does not pin array_nulls, so restore mangles NULL array elements