Update limitations for declarative partitioning
The release notes for pg 13 advertise a new feature in
https://www.postgresql.org/docs/13/release-13.html#DDL-PARTITION-PRUNING
-
Allow BEFORE row-level triggers
<https://www.postgresql.org/docs/13/triggers.html> on partitioned tables
(Álvaro Herrera)These triggers cannot change which partition is the destination.
- But the manual still warns at
https://www.postgresql.org/docs/13/ddl-partitioning.html#DDL-PARTITIONING-DECLARATIVE-LIMITATIONS
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
On 2020-Aug-08, Erwin Brandstetter wrote:
- But the manual still warns at
https://www.postgresql.org/docs/13/ddl-partitioning.html#DDL-PARTITIONING-DECLARATIVE-LIMITATIONSBEFORE 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."
Oh, right, I'll patch that up tomorrow. Thanks for pointing it out.
--
�lvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
Looking at
https://www.postgresql.org/docs/devel/ddl-partitioning.html#DDL-PARTITIONING-DECLARATIVE-LIMITATIONS
... the issue seems unchanged?
Regards
Erwin
On Sat, 8 Aug 2020 at 05:38, Alvaro Herrera <alvherre@2ndquadrant.com>
wrote:
Show quoted text
On 2020-Aug-08, Erwin Brandstetter wrote:
- But the manual still warns at
https://www.postgresql.org/docs/13/ddl-partitioning.html#DDL-PARTITIONING-DECLARATIVE-LIMITATIONS
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."
Oh, right, I'll patch that up tomorrow. Thanks for pointing it out.
--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
On Sun, Aug 30, 2020 at 11:39:59PM +0200, Erwin Brandstetter wrote:
Looking at
https://www.postgresql.org/docs/devel/ddl-partitioning.html#DDL-PARTITIONING-DECLARATIVE-LIMITATIONS
... the issue seems unchanged?
Indeed, there is no fix in the code tree. Alvaro? If there is no
update, I'll go fix that myself.
--
Michael