Feedback-ID: i76984098:Fastmail
Message-ID: <e781008b-5733-4298-aa57-90580f486eb4@aklaver.com>
Date: Thu, 13 Mar 2025 10:03:55 -0700
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Duplicate Key Values
To: mark bradley <markbradyju@outlook.com>,
 Ron Johnson <ronljohnsonjr@gmail.com>,
 pgsql-general <pgsql-general@postgresql.org>
References: <CH3PR22MB4312C23476C0E67F9B4C2E10BACB2@CH3PR22MB4312.namprd22.prod.outlook.com>
 <SJ2PR22MB4328A3EDC83E495DB9A4BD09BAD12@SJ2PR22MB4328.namprd22.prod.outlook.com>
 <84aac7bf-5638-4f1f-9772-ace0ea27e848@aklaver.com>
 <SJ2PR22MB4328CEB1B47FC1AC4A996CB3BAD12@SJ2PR22MB4328.namprd22.prod.outlook.com>
 <9203d0df-0ddd-4564-a985-59bcfcf1d294@aklaver.com>
 <SJ2PR22MB432802BD55A9AEFCF212F4A7BAD12@SJ2PR22MB4328.namprd22.prod.outlook.com>
 <d51484c7-6659-4552-b999-cc220a492f8e@aklaver.com>
 <d21319fa-169d-46d9-81c1-7e22bafe2a2b@aklaver.com>
 <08c96195-3d5f-4902-b5d7-15916a02e23f@aklaver.com>
 <SJ2PR22MB43283C748A57C46E382FF4A3BAD32@SJ2PR22MB4328.namprd22.prod.outlook.com>
 <CANzqJaDDg51R2UvWgSw10+zxN9BteocWOAyGwWpuPq9hYXKkJQ@mail.gmail.com>
 <SJ2PR22MB4328E65C7F54C164917C5063BAD32@SJ2PR22MB4328.namprd22.prod.outlook.com>
 <b63d28ca-d3be-4701-8752-3ee939133165@aklaver.com>
 <SJ2PR22MB4328FA1F103D7BC658A6987CBAD32@SJ2PR22MB4328.namprd22.prod.outlook.com>
Content-Language: en-US
From: Adrian Klaver <adrian.klaver@aklaver.com>
In-Reply-To: <SJ2PR22MB4328FA1F103D7BC658A6987CBAD32@SJ2PR22MB4328.namprd22.prod.outlook.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: <https://www.postgresql.org/message-id/e781008b-5733-4298-aa57-90580f486eb4%40aklaver.com>
Precedence: bulk

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/SJ2PR22MB4328CEB1B47FC1AC4A996CB3BAD12%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