Re: [Fwd: Re: Transactions and temp tables] - Mailing list pgsql-hackers

From Heikki Linnakangas
Subject Re: [Fwd: Re: Transactions and temp tables]
Date
Msg-id 49786E21.90503@enterprisedb.com
Whole thread Raw
In response to Re: [Fwd: Re: Transactions and temp tables]  (Bruce Momjian <bruce@momjian.us>)
List pgsql-hackers
Bruce Momjian wrote:
> Heikki Linnakangas wrote:
>> IMHO, this is just getting too kludgey. We came up with pretty good 
>> ideas on how to handle temp tables properly, by treating the same as 
>> non-temp tables. That should eliminate all the problems the latest patch 
>> did, and also the issues with sequences, and allow all access to temp 
>> tables, not just a limited subset. I don't think it's worthwhile to 
>> apply the kludge as a stopgap measure, let's do it properly in 8.5.
>> ...
> 
> Can someone tell me how this should be worded as a TODO item?

There already is a todo item about this:

"Allow prepared transactions with temporary tables created and dropped 
in the same transaction, and when an ON COMMIT DELETE ROWS temporary 
table is accessed "

I added a link to the email describing the most recent idea on how this 
should be implemented.

--   Heikki Linnakangas  EnterpriseDB   http://www.enterprisedb.com


pgsql-hackers by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: Pluggable Indexes (was Re: rmgr hooks (v2))
Next
From: Simon Riggs
Date:
Subject: Re: Pluggable Indexes (was Re: rmgr hooks (v2))