Postgres Pro
Downloads
Home   >   mailing lists

Update limitations for declarative partitioning - Mailing list pgsql-docs

From Erwin Brandstetter
Subject Update limitations for declarative partitioning
Date
Msg-id CAGHENJ6Le7S3qJJx2TvWvTwRNS3N=BtoNeb7AF2rZvfNBMeQcg@mail.gmail.com
Whole thread Raw
Responses Re: Update limitations for declarative partitioning
List pgsql-docs
Tree view
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

pgsql-docs by date:

Previous
From: Jürgen Purtz
Date:
Subject: Re: obsolete indexing method "rtree"
Next
From: Alvaro Herrera
Date:
Subject: Re: Update limitations for declarative partitioning