Re: [HACKERS] Partitioning vs ON CONFLICT

Поиск
Список
Период
Сортировка
Искать
От
Simon Riggs
Тема
Re: [HACKERS] Partitioning vs ON CONFLICT
Дата
Msg-id
CANP8+j+SgSShsRNFoRPXh1c0yp3D1R=H-uUkQotnAG+COVapow@mail.gmail.com
Ответ на
[HACKERS] Partitioning vs ON CONFLICT (Thom Brown)
Список
Дерево обсуждения
[HACKERS] Partitioning vs ON CONFLICT Thom Brown <thom@linux.com>
Re: [HACKERS] Partitioning vs ON CONFLICT Simon Riggs <simon@2ndquadrant.com>
Re: [HACKERS] Partitioning vs ON CONFLICT Peter Geoghegan <pg@bowt.ie>
Re: [HACKERS] Partitioning vs ON CONFLICT Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: [HACKERS] Partitioning vs ON CONFLICT Peter Geoghegan <pg@bowt.ie>
Re: [HACKERS] Partitioning vs ON CONFLICT Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: [HACKERS] Partitioning vs ON CONFLICT Peter Geoghegan <pg@bowt.ie>
Re: [HACKERS] Partitioning vs ON CONFLICT Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: [HACKERS] Partitioning vs ON CONFLICT Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Partitioning vs ON CONFLICT Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: [HACKERS] Partitioning vs ON CONFLICT Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: Partitioning vs ON CONFLICT Robert Haas <robertmhaas@gmail.com>
Re: Partitioning vs ON CONFLICT Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: Partitioning vs ON CONFLICT "Shinoda, Noriyoshi" <noriyoshi.shinoda@hpe.com>
Re: Partitioning vs ON CONFLICT Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: Partitioning vs ON CONFLICT Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: Partitioning vs ON CONFLICT Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: Partitioning vs ON CONFLICT Robert Haas <robertmhaas@gmail.com>
Re: Partitioning vs ON CONFLICT Peter Geoghegan <pg@bowt.ie>
Re: Partitioning vs ON CONFLICT Robert Haas <robertmhaas@gmail.com>
Re: Partitioning vs ON CONFLICT Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: [HACKERS] Partitioning vs ON CONFLICT Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Partitioning vs ON CONFLICT Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: [HACKERS] Partitioning vs ON CONFLICT Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Partitioning vs ON CONFLICT Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: [HACKERS] Partitioning vs ON CONFLICT Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: Partitioning vs ON CONFLICT Rukh Meski <rukh.meski@gmail.com>
Re: Partitioning vs ON CONFLICT Peter Geoghegan <pg@bowt.ie> 
On 16 February 2017 at 14:54, Thom Brown  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
В списке pgsql-hackers по дате отправления
Предыдущее
От: Surafel Temsgen
Дата:
Следующее
От: Robert Haas
Дата:
FAQ