Update limitations for declarative partitioning

Поиск
Список
Период
Сортировка
От Erwin Brandstetter
Тема Update limitations for declarative partitioning
Дата
Msg-id CAGHENJ6Le7S3qJJx2TvWvTwRNS3N=BtoNeb7AF2rZvfNBMeQcg@mail.gmail.com
обсуждение исходный текст
Ответы Re: Update limitations for declarative partitioning  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Список pgsql-docs
The release notes for pg 13 advertise a new feature in

  • Allow BEFORE row-level triggers on partitioned tables (Álvaro Herrera)

    These triggers cannot change which partition is the destination.

  • But the manual still warns at

BEFORE ROW triggers, if necessary, must be defined on individual partitions, not the partitioned table.

Looks like that "limitation" can go now? Or reduced to something like:

"BEFORE ROW triggers on the partitioned table cannot change which partition is the destination."

Regards
Erwin

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

Предыдущее
От: Jürgen Purtz
Дата:
Сообщение: Re: obsolete indexing method "rtree"
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: Update limitations for declarative partitioning