Re: Update of partition key on foreign server

2021-09-01 Thread Etsuro Fujita
On Thu, Aug 26, 2021 at 11:10 PM Ilya Gladyshev wrote: > I have developed a simple patch to fix this, while I’m not fully satisfied > with it, it gets the job done. Thanks for working on this! > In message [1] there’s also mentioned possibility of existence of triggers on > the foreign

Re: Update of partition key on foreign server

2021-08-26 Thread Ilya Gladyshev
2 авг. 2021 г., в 15:29, Илья Гладышев написал(а): Hi,I am currently looking into a partition constraint violation that occurs on update of a partition key on a foreign server. To reproduce it you can run:On server 1 using port 5432:

Update of partition key on foreign server

2021-08-02 Thread Илья Гладышев
Hi, I am currently looking into a partition constraint violation that occurs on update of a partition key on a foreign server. To reproduce it you can run: On server 1 using port 5432: create extension postgres_fdw; create table players (id integer, name text) partition by list(name); create