Request a Demo
Home   >   mailing lists

Re: Prevent setting NO INHERIT on partitioned not-null constraints - Mailing list pgsql-hackers

From Andreas Karlsson
Subject Re: Prevent setting NO INHERIT on partitioned not-null constraints
Date
Msg-id 7299e1c3-9cf5-4e72-94ae-1771d88fb0a3@proxel.se
Whole thread
In response to Re: Prevent setting NO INHERIT on partitioned not-null constraints  (Jim Jones <jim.jones@uni-muenster.de>)
Responses Re: Prevent setting NO INHERIT on partitioned not-null constraints
List pgsql-hackers
Tree view 
On 5/21/26 5:01 PM, Jim Jones wrote:
> The errcode is most likely wrong:
> 
> ERRCODE_WRONG_OBJECT_TYPE -> ERRCODE_FEATURE_NOT_SUPPORTED
> 
> At least it is inconsistent with an equivalent check in parse_utilcmd.c:
> 
> if (cxt->ispartitioned && constraint->is_no_inherit)
>    ereport(ERROR,
>       errcode(ERRCODE_FEATURE_NOT_SUPPORTED),
>            errmsg("not-null constraints on partitioned tables cannot be
> NO INHERIT"));

Thanks, that was a copy pasto. Version 2 is attached.

-- 
Andreas Karlsson
Percona
Attachment

pgsql-hackers by date:

Previous
From: Mohamed ALi
Date:
Subject: Re: [PATCH] Add NESTED_STATEMENTS option to EXPLAIN
Next
From: Dave Cramer
Date:
Subject: Re: Patch for bind message regarding the number of parameters and result column format codes