Postgres Pro
Downloads
Home   >   mailing lists

ON CONFLICT clause NOT working on Partition Table PostgreSQL 12 - Mailing list pgsql-sql

From Inzamam Shafiq
Subject ON CONFLICT clause NOT working on Partition Table PostgreSQL 12
Date
Msg-id AM9P251MB033090199F1A3C2B1742A50A98499@AM9P251MB0330.EURP251.PROD.OUTLOOK.COM
Whole thread Raw
Responses Re: ON CONFLICT clause NOT working on Partition Table PostgreSQL 12  (Steve Midgley <science@misuse.org>)
List pgsql-sql
Tree view

Hi Team,

I have a partitioned table in postgresql12 and the unique constraint is applied on the child tables, when I use ON CONFLICT clause it returned an error "duplicate key value violates unique constraint "..."", I tried to replicate the scenario on a test table and created a unique index on partition column and the unique column but when I try to insert data it again return the same error. 

This works successfully when I directly insert data in the child table.

What could be the way forward to get this work on parent table?

Thanks.

Cheers,

Inzamam Shafiq
Sr. DBA

pgsql-sql by date:

Previous
From: hubert depesz lubaczewski
Date:
Subject: Re: execution id
Next
From: Steve Midgley
Date:
Subject: Re: ON CONFLICT clause NOT working on Partition Table PostgreSQL 12