On 16 February 2017 at 14:54, Thom Brown <t...@linux.com> wrote: > 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?
Partitioned tables don't yet support a global unique constraint that would be required for support of ON CONFLICT processing. -- Simon Riggs http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers