Re: Is there a work around for partition key needed for constraint

Поиск
Список
Период
Сортировка
От legrand legrand
Тема Re: Is there a work around for partition key needed for constraint
Дата
Msg-id 1540532037246-0.post@n3.nabble.com
обсуждение исходный текст
Ответ на Re: Is there a work around for partition key needed for constraint  (Jorge Torralba <jorge.torralba@gmail.com>)
Список pgsql-admin
Дерево обсуждения 
Jorge Torralba wrote
> Thanks for the suggestion. But there is one slight problem :)
> 
> DETAIL:  Partitioned tables cannot have BEFORE / FOR EACH ROW triggers.

Given exemple, works on a 11beta2 release. Triggers have to be created at 
PARTITION level, not at TABLE level (where it is not supported ;o(.

Regards
PAscal



--
Sent from: http://www.postgresql-archive.org/PostgreSQL-admin-f2076596.html

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

Предыдущее
От: Jorge Torralba
Дата:
Сообщение: Re: Is there a work around for partition key needed for constraint
Следующее
От: Mark Steben
Дата:
Сообщение: hot standby cascading replication