Re: Multi-insert into a partitioned table with before insert rowtrigger causes server crash on latest HEAD
От | Peter Eisentraut |
---|---|
Тема | Re: Multi-insert into a partitioned table with before insert rowtrigger causes server crash on latest HEAD |
Дата | |
Msg-id | 568945fb-28a7-c06a-c65d-64eac471a3ee@2ndquadrant.com обсуждение исходный текст |
Ответ на | Re: Multi-insert into a partitioned table with before insert rowtrigger causes server crash on latest HEAD (Ashutosh Sharma <ashu.coek88@gmail.com>) |
Ответы |
Re: Multi-insert into a partitioned table with before insert rowtrigger causes server crash on latest HEAD
Re: Multi-insert into a partitioned table with before insert rowtrigger causes server crash on latest HEAD |
Список | pgsql-hackers |
On 16/10/2018 06:33, Ashutosh Sharma wrote: > I think, the root cause of this problem is that CopyFrom() is using > the stale value of *has_before_insert_row_trig* to determine if the > current partition is okay for multi-insert or not i.e. > has_before_insert_row_trig used to determine multi-insert condition > for the current partition actually belongs to old partition. I think, > *has_before_insert_row_trig* needs to updated before CopyFrom() > evaluates if the current partition is good to go for multi insert or > not. Attached is the patch based on this. I've also added the relevant > test-case for it. Peter, David, Could you please have a look into the > attached patch and share your thoughts. Thank you. I have committed your fix and test, moving some code around a bit. Thanks. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
В списке pgsql-hackers по дате отправления: