Re: Partitioning with temp tables is broken - Mailing list pgsql-hackers

From amul sul
Subject Re: Partitioning with temp tables is broken
Date
Msg-id CAAJ_b94k8JapK2JyfXqgN5SgyW07exYOX1ev7iDmOoMhV8aarw@mail.gmail.com
Whole thread Raw
In response to Re: Partitioning with temp tables is broken  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Partitioning with temp tables is broken
List pgsql-hackers
On Wed, Jun 13, 2018, 8:34 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
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.


+1, forbid the problematic case.

Regards, 
Amul
----------------------------------------------------------------------------------------------------
Sent from a mobile device. Please excuse brevity and tpyos. 

pgsql-hackers by date:

Previous
From: Teodor Sigaev
Date:
Subject: Re: POC: GROUP BY optimization
Next
From: Teodor Sigaev
Date:
Subject: Re: POC: GROUP BY optimization