Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tt3rw-008ANE-QE for pgsql-general@arkaria.postgresql.org; Fri, 14 Mar 2025 12:10:29 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tt3rv-005gI0-Ge for pgsql-general@arkaria.postgresql.org; Fri, 14 Mar 2025 12:10:27 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tt3ru-005gFi-UM for pgsql-general@lists.postgresql.org; Fri, 14 Mar 2025 12:10:27 +0000 Received: from mail-bn1nam02olkn2081e.outbound.protection.outlook.com ([2a01:111:f403:2c07::81e] helo=NAM02-BN1-obe.outbound.protection.outlook.com) by makus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1tt3rs-002nen-2z for pgsql-general@postgresql.org; Fri, 14 Mar 2025 12:10:26 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector10001; d=microsoft.com; cv=none; b=RHsDUx+i+8GmESkkKa/wHPxQcJbtPzhDnVslhxNHLQWVxwqUnEP9grFf+kZ0XxyI4JBNRSRgvVwipg14Jhg8S025SUTkvvsfKcgyr52xZqNaRcAI7NA0Rpe51O7QCHjBLyLNvPRUs+hS7Ik4vZxir/e1o1XiyxZ+urhiI3SMRUVY+XzFGDPWCz/M6bL2yXdkeZ31irgGA6jEDfQ6kMN1f5zL9DKfeG1xQhH5RRnhwiBnIa75oHITdrHrlG5U0ZjuSLnt7ibiwjs4EP36lOvGJLiMICCQlym5d9P2O2rfmDQ5GOHSSm3jJcLRlVJ8xXX/hWm9XsqUiuOteLGo/QzYfA== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector10001; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1; bh=msezz5BK/R9Z022Vtarv6SBE/j2V1u/IfEm+s4arFDI=; b=r1+FOaTeFoyZR2vQhS2y1YlF13Ops4HJzRG+MoKxLC9KgGzTg2tOyMlpLdqm8lwMVo4tlfB0mmS+p41URIx1vf1sjcnYifgZ9tUrjlpM6jabwYUboVRFawHbm3+e/GBR249kWk4jUjj7JKlE+QtgJsSyta91HardoJEjOWNJJYdJwmNLuV3IPhXT7oshirElcVUo4jhaaa7m3CYGS3VowRUqeJoROc7lPNSwHWdSH5NxEMXkABpcYdLe8Hq+TseZ9R95eO36Ngr02ZQHTcKVw18DztYx0WKztPskfSf072uWMkhtWxwezMOzpr7Vp4naPLIQX1BzQTTBBA0WmNnf1g== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=none; dmarc=none; dkim=none; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=outlook.com; s=selector1; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=msezz5BK/R9Z022Vtarv6SBE/j2V1u/IfEm+s4arFDI=; b=apGLKT9X0BZvSyUxfHR3yzorNHuOvuw3QFmMFu8jf0foguRcrw/Qcckljotw8xM9xu7R+NAdziOzrXtJitGAkrVLIXN7tqpAkCJXPaRnVrXgov9bExZjMcpz9meLfbm/sMzONoE7Qho6AxtgMc3p5EmlOf/bvbrOgoMM1CRQu3N/UN+geuK+WZvPb+wL4FDD+OQNwkocEhQ8bYSwhcyInkCiMwVgphfcEJM2O3WhI/lwSbBmCL2FDz/iYT5cfamgfzQMMTE+Rvl9G5y3PzrWaitJ3JjYpjrMdbUpiZjjoqEeFqu7L/9z0FiCmmKTFQl1j0fmLgf3O4eYrbZxa8u7/A== Received: from SJ2PR22MB4328.namprd22.prod.outlook.com (2603:10b6:a03:547::6) by DS7PR22MB3648.namprd22.prod.outlook.com (2603:10b6:8:77::17) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.8534.25; Fri, 14 Mar 2025 12:10:22 +0000 Received: from SJ2PR22MB4328.namprd22.prod.outlook.com ([fe80::2440:4b5e:d794:94e]) by SJ2PR22MB4328.namprd22.prod.outlook.com ([fe80::2440:4b5e:d794:94e%6]) with mapi id 15.20.8534.017; Fri, 14 Mar 2025 12:10:21 +0000 From: mark bradley To: Adrian Klaver , Ron Johnson , pgsql-general Subject: Re: Duplicate Key Values Thread-Topic: Duplicate Key Values Thread-Index: AQHbjfSQTi8IT+qnIE+vrsDEftWknrNk0i6AgABZWESAAAeigIAAA0qAgAEyu6OAAAQ9gIAACBsIgAAUTYCAAACl9oAACBWAgAEp+imAABowgIAAQNjvgAAKxYCABeQlYIAACUYAgAACETqAAAJXAIAAALnDgAAMoYCAABfCkYAAJO+AgAACozmAAAp6gIABRLeAgAAEAwCAAXIJboAAENCAgAAL/Z+AAAS9gIAAA3iNgAAM0oCAAUAd/w== Date: Fri, 14 Mar 2025 12:10:21 +0000 Message-ID: References: <84aac7bf-5638-4f1f-9772-ace0ea27e848@aklaver.com> <9203d0df-0ddd-4564-a985-59bcfcf1d294@aklaver.com> <08c96195-3d5f-4902-b5d7-15916a02e23f@aklaver.com> In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: msip_labels: x-ms-publictraffictype: Email x-ms-traffictypediagnostic: SJ2PR22MB4328:EE_|DS7PR22MB3648:EE_ x-ms-office365-filtering-correlation-id: 8bd4a3d3-3a3b-4d1a-7962-08dd62f13161 x-microsoft-antispam: BCL:0;ARA:14566002|15030799003|8062599003|8060799006|19110799003|12050799009|15080799006|461199028|9400799030|7092599003|41001999003|1602099012|10035399004|440099028|102099032|3412199025|4302099013; x-microsoft-antispam-message-info: =?us-ascii?Q?G0k8AaSeSGAKxTmT2izs3OtaGw0bcEAAPh5LO/YkywX/nm/ZF2/CDRZcsLUw?= =?us-ascii?Q?Oe2gxB5mHV30MMmL9AvgxQ02dt7PDJKfinRzJj24Zc2jJTfvroZYfOsZjiKy?= =?us-ascii?Q?XxGt7zDLpu5ni8QDvD9hxQIQj2ejlg6HLANlQeMsTTejxr/ulTjDMInY6KkK?= =?us-ascii?Q?MuJ1lrr/7j8PhpIRraxgbH0q4WkvaYNYWnjs7rOSyyxCCaX9yM3yNQM38+S+?= =?us-ascii?Q?uUAGGoFs00lUATg8xlLEDXCypPecItBlAnguki7NnCHAJ12qTX1dDj/+ROX6?= =?us-ascii?Q?E13RLzO3TXXckNJaPYYh5JBAqSsHf2zfYFfOhJ9lIwkJj280KiGDf8UntYYW?= =?us-ascii?Q?644RG8TfEHRpWATCp5QbJwF9eNaimxdD6f8FgTbePVLmkmV/6H3UcPoViliX?= =?us-ascii?Q?be2EAGT4z0r8NkAvLpSkE8DCDqBtgkelaLS2EMdDYL6+RlXNrs8pzh9pa6vc?= =?us-ascii?Q?M6Yey8ONR638FqFdC5N4bD5ptfCDgXmSEkrixQ3zbziDwlHZquar9M/8zSGZ?= =?us-ascii?Q?8mXpI4b5AtvNvqgm7dbOScpuXwq1pksbe+xXvizt9LeUftBP3rKZ/4NuAYmg?= =?us-ascii?Q?MyP1M6+ropuD11rKw3IfBDRpz3DMiLViRvjbjRA6RK9ic1oJnIqygUy8Kol1?= =?us-ascii?Q?DhyATw8hPx3+4Y2vZtzCe3O3RtTAcL3hpSrKWcwiezJQHFrS7JKmrM/HF/xu?= =?us-ascii?Q?8AEKgHfCD/lIz8Yjy/9EvzxQm3ovgsjj7NSoVzU/x5X3Yb8B2Ts24a789GyP?= =?us-ascii?Q?L01zZ6Kai5tCAZayMaL18A9luVFT8WyXbqcQOXo85sOHzVqblaOA82cToclt?= =?us-ascii?Q?TBHMIpNElJOWovUoPBQQcO5HIYOdsWVIqrblHerltDK+VOKEfwvHaJqClSCx?= =?us-ascii?Q?HW6a8MZGp5PDawXeyLvYS/1Er5l2iwqMOg1gjOpGvkC+UMY9SMYdD9IxSHrw?= =?us-ascii?Q?O2C56vXP1MPDKa28v8ilz3MpsVbW4Sa3/axfLwWOVwaiC/Xsge3LBAHNk1Ng?= =?us-ascii?Q?ed6Kv4mqda7XQf2CiUkPWCA1AK3mOGk8JfeY5+jvZD6ozwYdJXYlbRWwi4Em?= =?us-ascii?Q?4IVhN18N34aPp4zutETyH05vOkcZcRJQDxCHKp/hCZqHYGerCh6Tvc+6XAOu?= =?us-ascii?Q?dy38ubScHz3xvLvLboMk+QoLCGB7jjTSMQtmxgk591TMNaqNTu2t5sdJCQmt?= =?us-ascii?Q?sqe2teil7t0bHRAsfBwknUAtsrSunSSRlp3Ofz9QPS42oytl8+ePonrmo65d?= =?us-ascii?Q?9DAxOx/rkIS24i5Igx7AT6wM6xhBRe2if75pwZiljCtT/+FgAHqUC5mNC4IB?= =?us-ascii?Q?oqp/Wxiv+rItBB1rc+7bRAYD2kajjGO38BB1gHR6hv5mlw=3D=3D?= x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?us-ascii?Q?mtsTjrXhErSiJEr7Ks5/5vfs5t98px/iW7b6IExANWk3gObNVLd/KCvEv/Zd?= =?us-ascii?Q?SbG2CzwCQgAqonqFvOWYTt88CaJg/MZ5WZnPNBpShF2HaeV3BErwFJZMCbTu?= =?us-ascii?Q?Af2L5pWoZrT0I4r5gp12SBamrnLmuuPawY/OPRJIs7hCEnXhxEy5HLiCaKZp?= =?us-ascii?Q?7DRt4t98nefzY4HGkBPGB3dRudplVw72qJpjJ4IqGAbcOed8+TDn6HZORddU?= =?us-ascii?Q?9ruFbwhNp2EquXjxdMFwUYGGUVo8XhkOlBcHVI39Heagj7TB3J7K9Nb0Yl/B?= =?us-ascii?Q?cd/mLGJtlPvdu7f1yt2KX2sdmYslDA/nT5nRja8utqZqSUIMj6DZMJRCu+IV?= =?us-ascii?Q?Mz4Bq3KMLwFUXjabmSDUFuoRwalRPYtZAzKisRFz+XCe9VbFiHCoG0WtoAdh?= =?us-ascii?Q?Q5S9iuUAdnfUabSj/r6QYqupYigk7zTJcQ+6OvZ6Ulkjtbz5JzkRc31XHnOq?= =?us-ascii?Q?bYbd5g1TXlcdtLBtxNVnvBB0h23qMiyBLPlGOyp/XxLuAnpFZvUgV+M3X629?= =?us-ascii?Q?rDL/rq0VfGJizQdbUeHly0gdM92FY1FdICJnN04cstBzfk2VBLlMcJBA5RmO?= =?us-ascii?Q?gk0FAauYoKuKP8aBbi9IL/BPDfKf1E5bhIp4VVPFAr6aj0hThmlgl4AX/FbR?= =?us-ascii?Q?wvRkLMSpudffOQrRvEQACkUPBE/NYcrPrb/sSVjehQYzSQWO1Z6eGu20TSGz?= =?us-ascii?Q?3v/Iw4JEBDoJI9tBX4CDiIgpHfOvObJ8ztWMGbJVH2U9E1gHFD93OXq9Tuf/?= =?us-ascii?Q?3PBRQynlQ1UthxfVie8IfUKSB7xJNSa1njuYkQXrPyTGnK1GVikNmQWi0CiD?= =?us-ascii?Q?+jnd7/tfcR6XwVqGxoGunxZp7sYC/bej6CQm/iefqmnSjY5uxFOUCdlDSQFx?= =?us-ascii?Q?vXMo/98zoBNRXeutfCoS9QwiAEGIl8R1FKxBCt0c3u3sU+Kuoiu3kafcdXNf?= =?us-ascii?Q?wKVPjAis6Iru6FzTIxg4ImWOhVBjue0oymSLlbDiBfW0Gm/rqE/TIzq9RMxD?= =?us-ascii?Q?RSexGfcGUD0g4MTcKpSnLvMVw3Xp1dcFjY2zzHdTXb86K9xYGdYw9gfC0ww6?= =?us-ascii?Q?SShx9aVqxrBLHkGYGLwhMMVI3xgBsnAza1sFBfAeUpivvUMK2UhdwYQFv7Ul?= =?us-ascii?Q?5T+BuieprKRaFFaE6/mMqGjsQU6KfPBMDbpK0VGhTOVVGwy2Bi7mebSicOO2?= =?us-ascii?Q?nWgyuUTq/+li82swqpNfVfrwJ7a/6Iv7ThHRXTz4rPcef0EfY82uxhM+pY8?= =?us-ascii?Q?=3D?= Content-Type: multipart/alternative; boundary="_000_SJ2PR22MB43281A2F8D59C7B53479D789BAD22SJ2PR22MB4328namp_" MIME-Version: 1.0 X-OriginatorOrg: outlook.com X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: SJ2PR22MB4328.namprd22.prod.outlook.com X-MS-Exchange-CrossTenant-RMS-PersistedConsumerOrg: 00000000-0000-0000-0000-000000000000 X-MS-Exchange-CrossTenant-Network-Message-Id: 8bd4a3d3-3a3b-4d1a-7962-08dd62f13161 X-MS-Exchange-CrossTenant-originalarrivaltime: 14 Mar 2025 12:10:21.1485 (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: DS7PR22MB3648 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_SJ2PR22MB43281A2F8D59C7B53479D789BAD22SJ2PR22MB4328namp_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Adrian & Ron, Thank you for your assistance. Best regards, Mark Brady amazon.com/author/markjbrady ________________________________ From: Adrian Klaver Sent: Thursday, March 13, 2025 1:03 PM To: mark bradley ; Ron Johnson ; pgsql-general Subject: Re: Duplicate Key Values On 3/13/25 09:25, mark bradley wrote: > > > I'm assuming that by 'simple version' you mean no inheritance. > > Inheritance was not specified by me in either case. By simple, I mean Unless someone else is working on this code, it was done by you. Pretty sure it had to do with from this message: https://www.postgresql.org/message-id/SJ2PR22MB4328CEB1B47FC1AC4A996CB3BAD1= 2%40SJ2PR22MB4328.namprd22.prod.outlook.com "Although I did not explicitly use Postgres to declare inheritance, logically speaking table dataset and processing _node inherit or are subclasses of node because they are subclasses of node in a dataflow diagram." I'm guessing you actually did do the subclassing(inheritance) as it was an option presented in the pgAdmin4 CREATE TABLE screen. Anyway at this point the problem has been identified and a solution devised= . > that I used fewer columns in the test version, like so: > > > > Where *node_id* is a foreign key in dataset, and *node_type* is not. > > Best regards, > Mark Brady -- Adrian Klaver adrian.klaver@aklaver.com --_000_SJ2PR22MB43281A2F8D59C7B53479D789BAD22SJ2PR22MB4328namp_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable
Adrian & Ron,

Thank you for your assistance. 

Best regards,
Mark Brady
From: Adrian Klaver <adr= ian.klaver@aklaver.com>
Sent: Thursday, March 13, 2025 1:03 PM
To: mark bradley <markbradyju@outlook.com>; Ron Johnson <ro= nljohnsonjr@gmail.com>; pgsql-general <pgsql-general@postgresql.org&g= t;
Subject: Re: Duplicate Key Values
 
On 3/13/25 09:25, mark bradley wrote:
>
>  > I'm assuming that by 'simple version' you mean no inheritan= ce.
>
> Inheritance was not specified by me in either case.  By simple, I= mean

Unless someone else is working on this code, it was done by you.

Pretty sure it had to do with from this message:

https://www.postgre= sql.org/message-id/SJ2PR22MB4328CEB1B47FC1AC4A996CB3BAD12%40SJ2PR22MB4328.n= amprd22.prod.outlook.com

"Although I did not explicitly use Postgres to declare inheritance, logically speaking table dataset and processing _node inherit or are
subclasses of node because they are subclasses of node in a dataflow
diagram."

I'm guessing you actually did do the subclassing(inheritance) as it was an option presented in the pgAdmin4 CREATE TABLE screen.

Anyway at this point the problem has been identified and a solution devised= .



> that I used fewer columns in the test version, like so:
>
>
>
> Where *node_id* is a foreign key in dataset, and *node_type* = ;is not.
>
> Best regards,
> Mark Brady


--
Adrian Klaver
adrian.klaver@aklaver.com

--_000_SJ2PR22MB43281A2F8D59C7B53479D789BAD22SJ2PR22MB4328namp_--