From: Chengpeng Yan <chengpeng_yan@outlook.com>
To: Marko Grujic <markoog@gmail.com>
CC: "pgsql-bugs@lists.postgresql.org" <pgsql-bugs@lists.postgresql.org>
Subject: Re: BUG #19507: Auto-named partition table constraint conflicts
Thread-Topic: BUG #19507: Auto-named partition table constraint conflicts
Thread-Index: AQHc9AIWoFvnUMZbdUKY/CuYJ5a8hbYv7W+AgAABWACAAAIWAA==
Date: Fri, 5 Jun 2026 13:08:57 +0000
Message-ID: <2856BB12-6389-4F06-9B35-576B838B669E@Outlook.com>
References: <19507-78eec77213b5284f@postgresql.org>
 <8690FCD2-B96C-4C0B-BFAC-94E9383A47AA@Outlook.com>
 <CAKQrOnr621sTrm4=uqRikq=ZB+-qEb4tq5opPQTiF8J+xr-cwg@mail.gmail.com>
In-Reply-To: 
 <CAKQrOnr621sTrm4=uqRikq=ZB+-qEb4tq5opPQTiF8J+xr-cwg@mail.gmail.com>
Accept-Language: zh-CN, en-US
Content-Language: en-US
x-ms-exchange-messagesentrepresentingtype: 1
x-ms-publictraffictype: Email
x-ms-traffictypediagnostic: TYYPR01MB14116:EE_|OS9PR01MB16876:EE_
x-ms-office365-filtering-correlation-id: d93ce4a5-b914-47c3-8361-08dec3039a96
x-ms-exchange-slblob-mailprops: 
 jt3MPKJsIx9sQz0pu3WskAq89eF2IlSZQ044veHKLBPCfx7o67a+DjmPay6KD7L5wC/hSNborzQDG2SKNb1DJQfGLFQk+qAcS5sFLdCtQ6zV6DNGRyk0SeFCYV1ZWSociONLWrWbc4XA3T9NoqeA7SB/VM00rV+Ql5p5k6X2l+UT4kf/SY6tB1/1rb5cPb6I59AkMZKrq7lu+LCAOwwK9lFtFqjjvUFVajorlsho4l4kpI3Brxvof2pO3HKuiP+/WtatrwBu9F21AsIpn6CSgPDIaaGJuKyZreTA14yMT+M3bou5osR0I0k0ByfrQjAYFIJS9UxwzIG3URDBBjfsQ7Wm2gVgnt8QQP7lB656HkYXEDQKfrhaxZHgQwS59ODRRHOWKFZn369eQqdlgqF+PA2pG8yAzJH5MUG3N3Z0xbyGBCk72N6P8UFjyHbHGhtTEO158wY5ANHNNUkjjHSVtW6JwpSBUVozYZeGAlk2ZJP5yN56amJX7K495BD7u83401pLuyp67WFMzv59DYWPVgkgHX91VJqMKrL4L1KPKvRP8G7D4VVXIU9C1rBlhPq0tYpjNXNlRS+sPmUvJr8oUd/xm5cnfuQ9+SlqrP+TkDIdQmaYnBGAAeb1PS02g9RZ2Srg0ptGohbqgmUIojZdmuANXCX+pztRTEpJGbfRZWjiJ3vFEB01thE5cMIm6k4493mpVQgAsXDHvktYmpun0Jmih1QPpSQ5iGh+psViuJgSt3f4MBLu+FWala0JDJ7e
x-microsoft-antispam: 
 BCL:0;ARA:14566002|24121999003|19110799012|8060799015|8062599012|22091999003|24021099003|15080799012|31061999003|51005399006|3412199025|40105399003|440099028|4302099013|1602099012|10035399007|102099032;
x-microsoft-antispam-message-info: 
 =?us-ascii?Q?ZHtKiiR6eFtMtkqg5ebBcgd3nubQs5EPe89+hqK4S15YBC3QHMOf/5J5Ka59?=
 =?us-ascii?Q?RYXxC3KK+vV+X4wW0Fn5ou3SoS1ZVuakzBHN+QImIv3pR7bdmvYvKkVOD7A8?=
 =?us-ascii?Q?SCF8sfubC3ovE34dTbMAeEQLma+AtVbcnA+HaY0NjguQu8/u3SiAc4HO6J1o?=
 =?us-ascii?Q?iRbZFszL9bJeP1GaLw6Ko4nLLmKqvkfM4e9GZjaXWJQxk165Z22b9IE4iJ0b?=
 =?us-ascii?Q?EiPr62KmR9PesnrW+qhcU8k7hxHfdhvDYLbtBF4Yg0oYGzf+Eiat1IUxXKBc?=
 =?us-ascii?Q?M+IM287JwhOpAcEB0VAe8RAJaz0E97ZNuzZKx6nyUs0Hn0elwAnUUN78XpbQ?=
 =?us-ascii?Q?mpk7kcIt1juMzyCoVZMQXKA5V0wkLKLAneA/gBcG9nyxyGZbYkYTe6ZE0gxS?=
 =?us-ascii?Q?8c/OtUdkjbgGGGiyeQXlieMcUkoLFBb8sX9iX1cvGK75EB8GU4+4WX5Xglde?=
 =?us-ascii?Q?MgY/WCuuO03YQg7APXfd3ybfqMh7BWMxiCpTPY2/YtQ0IryUupY/S3CXy2gt?=
 =?us-ascii?Q?hRksXP0snqN1MQUkLWByaZ+Dh6J/OkzEeYfjFjwyYn9Kqx1HA9uVe4WEG4Ow?=
 =?us-ascii?Q?SCuKvs4bYAIb3CVGCEBNlHTpUXmob7U8404TbPNoMwAGIHJse97TH67GIBPE?=
 =?us-ascii?Q?RF+ZYZfBy0xVn7sRYqfjxSk9k7Oz2XhFkmYfkTo5ODcIFpxOR4ZPZpQBBbvl?=
 =?us-ascii?Q?BgNJo8h+xQEQ4wk+EH3HWVOXGVby+QsnvdwYhJvV3ClX6AjwdY784DsiwoZB?=
 =?us-ascii?Q?ydbbLOaqZ6doJ1L8T5Gi9xe5EzoMgiV+C8jyHtENIO0hW5IqiqI9TdQqV/Mj?=
 =?us-ascii?Q?M0auFUtcV0DzWBE2E0V0/D/U+Mk03/QdWg0md23p3jO7H6QSYczV19nA9i4h?=
 =?us-ascii?Q?x63Bfdt7ibzFK/6g5F/b3zDJ+fv8BPXaag6g+RjD2ZgQGIUxPLpjKrV9jO3W?=
 =?us-ascii?Q?w6Lkdf/g6TXfAHXNA+ge9KX7nbQ/soz1DigEYxwvp/zFdF5Z1Q1shtOP5T2O?=
 =?us-ascii?Q?m6NPMsPPr+x1A5VOpPas9zPX319orMvMGkEROYRLOoJmj/I=3D?=
x-ms-exchange-antispam-messagedata-chunkcount: 1
x-ms-exchange-antispam-messagedata-0: 
 =?us-ascii?Q?1h+1+zltMqOA5nGpQuu+9o1GbMjZ67DUJWm6pWBxq1mGOlmeFrOGu4nMLZ4f?=
 =?us-ascii?Q?PFSFl3lkCRu01V4ZnWRtvL/YXidFEb0zR/3OUYeeMSPHeiqgMHimjkzXCewr?=
 =?us-ascii?Q?LALl9K5SXUM4nhmXd0EoLytcvzSuEBGW6AStmGISkPW46BYyxSEtznXXqOzV?=
 =?us-ascii?Q?70mgVAe/OmjwJPkZ7A6WET98iy085mXDLu4Ipwu7xNVOicN1qa88BA0eGklt?=
 =?us-ascii?Q?62BfKACdZYZh6Z+pNBznVtEAFA5yRVGHGtEo78W/1MElaSI9PXefqoC2eoIY?=
 =?us-ascii?Q?TVBWEDFHN4wriB4f9yYVSKzPbTV7qtJ0rOAHf4gK8R0XGcGna5Y0nXtpQulI?=
 =?us-ascii?Q?avmaRA2Iynxz6md3yvIjggSN0DY5y6OjMIdXdzM8dVC4O0RgyhB6w9UbeCEe?=
 =?us-ascii?Q?8bqQLH2SJiSIpScCC06fX4WFZPFxfx5GTqRPA8qA5rxrgbZQG37vXSSZFZ5v?=
 =?us-ascii?Q?CCTYI26yf+0ue+1QCEzc+xsC2agZ5c1hNjgGc2joFujCGRNdM1QobTnotakj?=
 =?us-ascii?Q?SOwVpXYOc6ej5C2xw7P3eqpJniasR/JkKlnXoI8AjaITOvjoqy72Ie2mK6DN?=
 =?us-ascii?Q?sBPylGErqJBSIBHkkQhRMna+tR3lDWIjYmT5jQExtnUKLlPi5gRXPfPFMrqu?=
 =?us-ascii?Q?AOqqLvAEToFxAPpz5cWD//Z01QCy2ZGtscWm95BzZBekM5K/dnySAIZ9MDLb?=
 =?us-ascii?Q?CdTjwGjrLMnwbmsKX0b4WQrsBypWHwH5HCoHfdN2RGakK9EFw3QxWwmBQUyR?=
 =?us-ascii?Q?wvtfy4y1T2YlhUqsewjzj4nVLbd//idWrBkxY/2xwSiyYrQfcaNuBoizRm94?=
 =?us-ascii?Q?LAOpSH26KZqfd7lqaBJm5LStUeJRxp80o6nyTXqWmTvuJvtfH9QWNeyg2n+V?=
 =?us-ascii?Q?4udcrA2pt0vdVCwLMvKMHbLEMqtX9NuUmGlwLOcSn3xDMoQ0IAW7es/RUJCy?=
 =?us-ascii?Q?SEjUvZcGcT5OL/BJbDo0a6wAWskLdVj9/TZrOzZijN1g55BTv9auRpM/p0k3?=
 =?us-ascii?Q?8DFCRcIQbgIl5jqLyIochSHcdpJkP8Gq3HR1N41GJT4IYqvZVlsLcVuH6VoG?=
 =?us-ascii?Q?NFWsjVLz3jYUCMDWxdTP3aoqHGDezoA30bmVZlPXASniplFZU01gcmvhrS2K?=
 =?us-ascii?Q?NW7+PUtLPlc61/AF1+ah7w3Tmu2sqM/xS38/h4t83x54jeuY2IOEIrJ+LyO9?=
 =?us-ascii?Q?I0tEGr/doLwp7Rdcdpzbyn0FKL37QxoSGjUUDZ0nm2WMUe40YtuJcg83x3QL?=
 =?us-ascii?Q?a1bg+wM1zLTKh7RU44uyOFdd2p1ZSR+AfBT8JODRcHx2o9T2N/JDcVMxXHCR?=
 =?us-ascii?Q?2SiQ823H4e4jUsjSbKRMwoEGDGMSIL1LcZk5ErG0aJT+WudjRu+YeOnttsBH?=
 =?us-ascii?Q?Zx7ORcqN2xIc9SZUf0bKcyM9L4vbhZXWTRANAel/Nuqie9eBeQ=3D=3D?=
Content-Type: text/plain; charset="us-ascii"
Content-ID: <8E77BD670CDE5943AE246986762EB702@jpnprd01.prod.outlook.com>
Content-Transfer-Encoding: quoted-printable
MIME-Version: 1.0
X-OriginatorOrg: outlook.com
X-MS-Exchange-CrossTenant-AuthAs: Internal
X-MS-Exchange-CrossTenant-AuthSource: TYYPR01MB14116.jpnprd01.prod.outlook.com
X-MS-Exchange-CrossTenant-RMS-PersistedConsumerOrg: 
 00000000-0000-0000-0000-000000000000
X-MS-Exchange-CrossTenant-Network-Message-Id: 
 d93ce4a5-b914-47c3-8361-08dec3039a96
X-MS-Exchange-CrossTenant-originalarrivaltime: 05 Jun 2026 13:08:57.8874
 (UTC)
X-MS-Exchange-CrossTenant-fromentityheader: Hosted
X-MS-Exchange-CrossTenant-id: 84df9e7f-e9f6-40af-b435-aaaaaaaaaaaa
X-MS-Exchange-CrossTenant-rms-persistedconsumerorg: 
 00000000-0000-0000-0000-000000000000
X-MS-Exchange-Transport-CrossTenantHeadersStamped: OS9PR01MB16876
List-Id: <pgsql-bugs.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-bugs@lists.postgresql.org>
List-Owner: <mailto:pgsql-bugs-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-bugs>
Archived-At: 
 <https://www.postgresql.org/message-id/2856BB12-6389-4F06-9B35-576B838B669E%40Outlook.com>
Precedence: bulk


> On Jun 5, 2026, at 21:01, Marko Grujic <markoog@gmail.com> wrote:
>=20
> Hi Chengpeng,
>=20
> Thanks for the heads up.
>=20
> > My current plan is to preserve the
> existing behavior for explicitly named constraints, but make
> automatically generated names avoid conflicts that would be hit during
> recursive propagation. In other words, when considering a generated
> candidate name for the parent, the code should also consider whether
> using that name throughout the relevant partition/inheritance tree would
> run into a name conflict.
>=20
> Fyi, I also have a patch up already with that exact purpose: https://www.=
postgresql.org/message-id/CAOvwyF1JsmerqF6hA005rb6YLP%3DpQAPOJCAKnr398%3D0R=
eZG%3DAA%40mail.gmail.com
>=20
> Cheers,
> Marko


Sorry, I hadn't noticed that you had already posted a patch for this.

Thanks for pointing it out. I'll take a look and try to review it when I
get some time.

--
Best regards,
Chengpeng Yan=