Re: Update limitations for declarative partitioning

2020-08-07 Thread Alvaro Herrera
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. > > > >

Update limitations for declarative partitioning

2020-08-07 Thread Erwin Brandstetter
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 > on partitioned tables > (Álvaro Herrera) > > These triggers cannot change which

Re: obsolete indexing method "rtree"

2020-08-07 Thread Jürgen Purtz
On 06.08.20 10:12, David G. Johnston wrote: On Thu, Aug 6, 2020 at 12:18 AM Jürgen Purtz > wrote: > Why? Because it can hinder the learning process. FWIW I'd at least fixup comment.sgml to reference a current type.  And while in there might as well add miss