RE: Duplicate key in UUID primary key index...

From: Eric Tobias <ettobias(at)hotmail(dot)com>
To: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: RE: Duplicate key in UUID primary key index...
Date: 2021-10-14 12:56:24
Message-ID: MW3PR17MB4186EBF90D311750CB964C44DCB89@MW3PR17MB4186.namprd17.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

It turns out the issue was related to JSON and the UUID. I had a single row of data being inserted from the "source" side, but there were two rows contained in JSON within one of the fields. My extract pattern denormalized the JSON content and caused two records to be insert... with the same UUID. I should have thought of the JSON part!

Thank you for all the assistance, everyone.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message James Tobin 2021-10-14 13:00:05 JOB | DBA (Canada)
Previous Message Cedric Rey 2021-10-14 12:34:42 Certificate validity error download.postgresql.org