public inbox for [email protected]
help / color / mirror / Atom feedFrom: Rushabh Lathia <[email protected]>
To: Alvaro Herrera <[email protected]>
Cc: PostgreSQL Hackers <[email protected]>
Subject: Re: Support NOT VALID / VALIDATE constraint options for named NOT NULL constraints
Date: Mon, 10 Feb 2025 00:28:45 +0530
Message-ID: <CAGPqQf21cWsCujW8U90VR4wdr+VEB+LMAwkNjYwS112_gS20pA@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <CAGPqQf0KitkNack4F5CFkFi-9Dqvp29Ro=EpcWt=4_hs-Rt+bQ@mail.gmail.com>
<[email protected]>
On Fri, Feb 7, 2025 at 4:44 PM Alvaro Herrera <[email protected]>
wrote:
>
> Recursion to child tables is incorrectly trying to locate the constraint
> by name:
>
> create table notnull_tbl1 (a int);
> alter table notnull_tbl1 add constraint foo not null a not valid;
> create table notnull_chld (a int);
> alter table notnull_chld add constraint blah not null a not valid;
> alter table notnull_chld inherit notnull_tbl1 ;
>
> -- this fails but shouldn't:
> alter table notnull_tbl1 validate constraint foo;
> ERROR: constraint "foo" of relation "notnull_chld" does not exist
>
> The end result here should be that the constraint `blah` in table
> notnull_chld is marked as validated.
>
Yes, I agree. Here we need a separate Queue for NotNull constraint
validation,
which fetches the respective Non-Validate-Not-Null constraint name from
the child table
I am working on the patch and will post the update patch soon.
>
> --
> Álvaro Herrera 48°01'N 7°57'E —
> https://www.EnterpriseDB.com/
> Syntax error: function hell() needs an argument.
> Please choose what hell you want to involve.
>
--
Rushabh Lathia
view thread (8+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected]
Subject: Re: Support NOT VALID / VALIDATE constraint options for named NOT NULL constraints
In-Reply-To: <CAGPqQf21cWsCujW8U90VR4wdr+VEB+LMAwkNjYwS112_gS20pA@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox