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

  1. doc: Update partitioning limitation on BEFORE triggers