Re: Partitioning with temp tables is broken
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Cc: David Rowley <david.rowley@2ndquadrant.com>,
PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>,
Robert Haas <robertmhaas@gmail.com>
Date: 2018-06-13T15:03:59Z
Lists: pgsql-hackers
Ashutosh Bapat <ashutosh.bapat@enterprisedb.com> writes: > [ lots o' problems with $subject ] > But a larger question is what use such temporary partitions are? > Should we just prohibit adding temporary partitions to a permanant > partitioned table? We should allow adding temporary partitions to a > temporary partitioned table if only they both belong to the same > session. Even if you want to argue that there's a use case for these situations, it seems far too late in the release cycle to be trying to fix all these issues. I think we need to forbid the problematic cases for now, and leave relaxing the prohibition to be treated as a future new feature. regards, tom lane
Commits
-
Clarify use of temporary tables within partition trees
- 5862174ec78a 10.5 landed
- 1c7c317cd9d1 11.0 landed