Re: Update limitations for declarative partitioning
Erwin Brandstetter <brsaweda@gmail.com>
From: Erwin Brandstetter <brsaweda@gmail.com>
To: pgsql-docs@lists.postgresql.org
Cc: Alvaro Herrera <alvherre@2ndquadrant.com>
Date: 2020-08-30T21:39:59Z
Lists: pgsql-docs
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: > 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 >
Commits
-
doc: Update partitioning limitation on BEFORE triggers
- 0ebe82a9413f 14.0 landed
- 97dc0d1d5891 13.0 landed