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 по дате отправления:

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: Large writable variables
Следующее
От: Adam Brusselback
Дата:
Сообщение: Re: Implementation of Flashback Query