From: Alvaro Herrera <alvherre@2ndquadrant.com>
To: Erwin Brandstetter <brsaweda@gmail.com>
Cc: pgsql-docs@lists.postgresql.org
Subject: Re: Update limitations for declarative partitioning
Date: Fri, 7 Aug 2020 23:38:19 -0400
Message-ID: <20200808033819.GA15523@alvherre.pgsql> (raw)
In-Reply-To: <CAGHENJ6Le7S3qJJx2TvWvTwRNS3N=BtoNeb7AF2rZvfNBMeQcg@mail.gmail.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: alvherre@2ndquadrant.com, brsaweda@gmail.com, pgsql-docs@lists.postgresql.org
Subject: Re: Update limitations for declarative partitioning
In-Reply-To: <20200808033819.GA15523@alvherre.pgsql>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox