Update limitations for declarative partitioning

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
5 messages Options
Reply | Threaded
Open this post in threaded view
|

Update limitations for declarative partitioning

Erwin Brandstetter-4
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
    Reply | Threaded
    Open this post in threaded view
    |

    Re: Update limitations for declarative partitioning

    Alvaro Herrera-9
    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 | Threaded
    Open this post in threaded view
    |

    Re: Update limitations for declarative partitioning

    Erwin Brandstetter-4
    Looking at
    ... the issue seems unchanged?

    Regards
    Erwin



    On Sat, 8 Aug 2020 at 05:38, Alvaro Herrera <[hidden email]> 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
    Reply | Threaded
    Open this post in threaded view
    |

    Re: Update limitations for declarative partitioning

    Michael Paquier-2
    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

    signature.asc (849 bytes) Download Attachment
    Reply | Threaded
    Open this post in threaded view
    |

    Re: Update limitations for declarative partitioning

    Michael Paquier-2
    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

    signature.asc (849 bytes) Download Attachment