Postgres Pro
Downloads
Home   >   mailing lists

[HACKERS] Partitioning vs ON CONFLICT - Mailing list pgsql-hackers

From Thom Brown
Subject [HACKERS] Partitioning vs ON CONFLICT
Date
Msg-id CAA-aLv7Z4uygtq-Q5CvDi9Y=VZxUyEnuWjL=EwCfOof=L04hgg@mail.gmail.com
Whole thread Raw
Responses Re: [HACKERS] Partitioning vs ON CONFLICT
List pgsql-hackers
Tree view 
Hi,

At the moment, partitioned tables have a restriction that prevents
them allowing INSERT ... ON CONFLICT ... statements:

postgres=# INSERT INTO cities SELECT 1, 'Crawley',105000 ON CONFLICT
(city_id) DO NOTHING;
ERROR:  ON CONFLICT clause is not supported with partitioned tables

Why do we have such a restriction?  And what would it take to remove it?

Thanks

Thom

pgsql-hackers by date:

Previous
From: Amit Kapila
Date:
Subject: Re: [HACKERS] Write Ahead Logging for Hash Indexes
Next
From: Surafel Temsgen
Date:
Subject: Re: [HACKERS] New CORRESPONDING clause design