Re: not null constraints, again

Alvaro Herrera <alvherre@alvh.no-ip.org>

From: Alvaro Herrera <alvherre@alvh.no-ip.org>
To: Pg Hackers <pgsql-hackers@lists.postgresql.org>
Cc: jian he <jian.universality@gmail.com>, Tender Wang <tndrwang@gmail.com>
Date: 2024-10-04T13:11:44Z
Lists: pgsql-hackers

Attachments

Here's v8 of this patch.

Tests are ok: https://cirrus-ci.com/build/5744512465633280

My next step is to write the complete commit message to explain it in
detail and put it to sleep on November's commitfest.

-- 
Álvaro Herrera         PostgreSQL Developer  —  https://www.EnterpriseDB.com/

Commits

  1. Suppress "may be used uninitialized" warnings from older compilers.

  2. Elide not-null constraint checks on child tables during PK creation

  3. Remove unnecessary code to handle CONSTR_NOTNULL

  4. Silence compilers about extractNotNullColumn()

  5. Add pg_constraint rows for not-null constraints