Re: Locks on temp table and PREPARE

Tom Lane wrote:
> Emmanuel Cecchet  writes:
>   
>> But when the transaction prepares, we know that. What would prevent us 
>> to do at prepare time the same cleanup that commit does?
>>     
>
> The entire point of PREPARE is that it's *not* committed yet.
>   
Agreed but all objects that were created and dropped in the transaction 
are going to be cleaned up whether the transaction commits or rollbacks. 
It seems that releasing these resources at PREPARE time would help for 
these 'temporary' objects that only have a transaction scope, right?
                     regards, manu