Re: Support NOT VALID / VALIDATE constraint options for named NOT NULL constraints

From: Álvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: "jian he" <jian(dot)universality(at)gmail(dot)com>, "Rushabh Lathia" <rushabh(dot)lathia(at)gmail(dot)com>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Support NOT VALID / VALIDATE constraint options for named NOT NULL constraints
Date: 2025-04-06 04:56:30
Message-ID: 7b188cf1-c618-42cc-bd18-27dfcc6e8ea4@app.fastmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi

I've been giving this some final polish which have me time to think it through, and I think Peter is right. We should not be adding the new column, but instead RelationBuildTupleDesc should use its existing scan of pg_constraint to determine validity status of constraints. We may need in addition a further value for attnullability that means unknown, "a constraint exists but we don't know yet if it's valid or invalid" for the times when we scanned pg_attribute but not yet pg_constraint. I think it's not too large a patch on top of that we have.

I'm going on a little excursion now but should be back to work on this in a couple of hours.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Masahiko Sawada 2025-04-06 05:01:34 Re: Parallel heap vacuum
Previous Message Tender Wang 2025-04-06 04:02:38 Re: Removing unneeded self joins