Re: FOR EACH ROW triggers on partitioned tables

Поиск
Список
Период
Сортировка
От Amit Langote
Тема Re: FOR EACH ROW triggers on partitioned tables
Дата
Msg-id 31cbde32-f389-8c0f-b5f3-37d7e7235ab8@lab.ntt.co.jp
обсуждение исходный текст
Ответ на Re: FOR EACH ROW triggers on partitioned tables  (Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>)
Список pgsql-hackers
On 2018/04/30 18:38, Ashutosh Bapat wrote:
> On Fri, Mar 23, 2018 at 7:19 PM, Alvaro Herrera <alvherre@alvh.no-ip.org> wrote:
>> Pushed.  Thanks for all the review.
>>
> 
> https://www.postgresql.org/docs/devel/static/ddl-partitioning.html
> 
> section 5.10.2.3 still says
> "Row triggers, if necessary, must be defined on individual partitions,
> not the partitioned table."
> 
> Should that change?
> 
> Per commit 86f575948c773b0ec5b0f27066e37dd93a7f0a96, we are supporting
> only AFTER row triggers. May be we should change the above line to
> "Before row triggers, if necessary, must ....".

A patch to fix that has been posted.

https://www.postgresql.org/message-id/9386c128-1131-d115-cda5-63ac88d15db1%40lab.ntt.co.jp

Thanks,
Amit



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

Предыдущее
От: Craig Ringer
Дата:
Сообщение: Re: Postgres, fsync, and OSs (specifically linux)
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: [HACKERS] proposal: schema variables