Re: Update limitations for declarative partitioning

Alvaro Herrera <alvherre@2ndquadrant.com>

From: Alvaro Herrera <alvherre@2ndquadrant.com>
To: Erwin Brandstetter <brsaweda@gmail.com>
Cc: pgsql-docs@lists.postgresql.org
Date: 2020-08-08T03:38:19Z
Lists: pgsql-docs
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

  1. doc: Update partitioning limitation on BEFORE triggers