Postgres Pro
Downloads
Home   >   mailing lists

Thread: Update limitations for declarative partitioning

Update limitations for declarative partitioning

From
Erwin Brandstetter
Date:
The release notes for pg 13 advertise a new feature in

  • Allow BEFORE row-level triggers on partitioned tables (Álvaro Herrera)

    These triggers cannot change which partition is the destination.

  • But the manual still warns at

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."

Regards
Erwin

Re: Update limitations for declarative partitioning

From
Alvaro Herrera
Date:
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

Re: Update limitations for declarative partitioning

From
Erwin Brandstetter
Date:
Looking at
... 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

Re: Update limitations for declarative partitioning

From
Michael Paquier
Date:
On Sun, Aug 30, 2020 at 11:39:59PM +0200, Erwin Brandstetter wrote:
> Looking at
> https://www.postgresql.org/docs/devel/ddl-partitioning.html#DDL-PARTITIONING-DECLARATIVE-LIMITATIONS
> ... the issue seems unchanged?

Indeed, there is no fix in the code tree.  Alvaro?  If there is no
update, I'll go fix that myself.
--
Michael
Attachment

Re: Update limitations for declarative partitioning

From
Michael Paquier
Date:
On Mon, Aug 31, 2020 at 11:18:55AM +0900, Michael Paquier wrote:
> Indeed, there is no fix in the code tree.  Alvaro?  If there is no
> update, I'll go fix that myself.

For the archives: this has been done with 97dc0d1.

(Thanks, Alvaro!)
--
Michael
Attachment