Date: Fri, 7 Aug 2020 23:38:19 -0400
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
Message-ID: <20200808033819.GA15523@alvherre.pgsql>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: 
 <CAGHENJ6Le7S3qJJx2TvWvTwRNS3N=BtoNeb7AF2rZvfNBMeQcg@mail.gmail.com>
User-Agent: Mutt/1.10.1 (2018-07-13)
Precedence: bulk

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