| From: | Erwin Brandstetter <brsaweda(at)gmail(dot)com> |
|---|---|
| To: | pgsql-docs(at)lists(dot)postgresql(dot)org |
| Subject: | Update limitations for declarative partitioning |
| Date: | 2020-08-08 02:16:04 |
| Message-ID: | CAGHENJ6Le7S3qJJx2TvWvTwRNS3N=BtoNeb7AF2rZvfNBMeQcg@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-docs |
The release notes for pg 13 advertise a new feature in
https://www.postgresql.org/docs/13/release-13.html#DDL-PARTITION-PRUNING
-
>
> Allow BEFORE row-level triggers
> <https://www.postgresql.org/docs/13/triggers.html> on partitioned tables
> (Álvaro Herrera)
>
> These triggers cannot change which partition is the destination.
>
- 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."
Regards
Erwin
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2020-08-08 03:38:19 | Re: Update limitations for declarative partitioning |
| Previous Message | Jürgen Purtz | 2020-08-07 15:46:45 | Re: obsolete indexing method "rtree" |