Re: Can't find not null constraint, but \d+ shows that - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: Can't find not null constraint, but \d+ shows that
Date
Msg-id 202404101723.4ag5z2mbgmsl@alvherre.pgsql
Whole thread Raw
In response to Re: Can't find not null constraint, but \d+ shows that  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Responses Re: Can't find not null constraint, but \d+ shows that  (jian he <jian.universality@gmail.com>)
List pgsql-hackers
On 2024-Apr-10, Alvaro Herrera wrote:

> One thing missing here is pg_dump support.  If you just dump this table,
> it'll end up with no constraint at all.  That's obviously bad, so I
> propose we have pg_dump add a regular NOT NULL constraint for those, to
> avoid perpetuating the weird situation further.

Here's another crude patchset, this time including the pg_dump aspect.

-- 
Álvaro Herrera        Breisgau, Deutschland  —  https://www.EnterpriseDB.com/
"On the other flipper, one wrong move and we're Fatal Exceptions"
(T.U.X.: Term Unit X  - http://www.thelinuxreview.com/TUX/)

Attachment

pgsql-hackers by date:

Previous
From: Dmitry Koval
Date:
Subject: Re: Add SPLIT PARTITION/MERGE PARTITIONS commands
Next
From: Robert Haas
Date:
Subject: Re: Table AM Interface Enhancements