ON CONFLICT clause NOT working on Partition Table PostgreSQL 12
Inzamam Shafiq <inzamam.shafiq@hotmail.com>
From: Inzamam Shafiq <inzamam.shafiq@hotmail.com>
To: "pgsql-sql@lists.postgresql.org" <pgsql-sql@lists.postgresql.org>
Date: 2022-09-15T17:31:47Z
Lists: pgsql-sql
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