Re: a misbehavior of partition row movement (?)

Поиск
Список
Период
Сортировка
От Rahila Syed
Тема Re: a misbehavior of partition row movement (?)
Дата
Msg-id CAH2L28tHrUn_J0+DDY1ba91QkAOfV7bb=RKekRN6naYroJXS6Q@mail.gmail.com
обсуждение исходный текст
Ответ на Re: a misbehavior of partition row movement (?)  (Amit Langote <amitlangote09@gmail.com>)
Ответы Re: a misbehavior of partition row movement (?)
Список pgsql-hackers
Дерево обсуждения
Hi Amit,



Here is an updated version of the patch with some cosmetic changes
from the previous version.  I moved the code being added to
AfterTriggerSaveEvent() and ExecUpdate() into separate subroutines to
improve readability, hopefully.

I tested these patches. It works as expected in case of cross partition updates, by correctly updating the
referencing table.  It works fine for ON UPDATE SET NULL and SET DEFAULT options as well. 
Also, tested by having a table reference only a partition and not the parent. In this case, the delete 
trigger is correctly called when the row is moved out of referenced partition. 

The partition-key-update-1.spec test fails with the following error message appearing in the diffs.

 step s1u3pc: UPDATE foo_range_parted SET a=11 WHERE a=7;
+ERROR:  cannot move row being updated to another partition

I think the documentation update is missing from the patches. 
 
Thank you,
Rahila Syed

В списке pgsql-hackers по дате отправления: