| From: | Andreas Karlsson <andreas(at)proxel(dot)se> |
|---|---|
| To: | Jim Jones <jim(dot)jones(at)uni-muenster(dot)de>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Prevent setting NO INHERIT on partitioned not-null constraints |
| Date: | 2026-05-21 21:22:31 |
| Message-ID: | 7299e1c3-9cf5-4e72-94ae-1771d88fb0a3@proxel.se |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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 | Content-Type | Size |
|---|---|---|
| v2-0001-Prevent-setting-NO-INHERIT-on-paritioned-not-null.patch | text/x-patch | 3.4 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dave Cramer | 2026-05-21 21:55:35 | Re: Patch for bind message regarding the number of parameters and result column format codes |
| Previous Message | Mohamed ALi | 2026-05-21 20:51:58 | Re: [PATCH] Add NESTED_STATEMENTS option to EXPLAIN |