Hi all,
Here is a new version of the patch still based on the last proposal by
Heikki.
This patch only support temp tables that are created AND dropped in the
same transaction. This works with any kind of temp table (with on commit
options or not).
This simplifies the problem since the temp tables we consider here
cannot be accessed by another backend anyway since their scope is the
one of the transaction.
We do NOT allow:
- access to temp tables that were not created AND dropped in the transaction
- created temp tables that are not dropped at prepare time
- dropped temp tables that were not created in the transaction
The attached patch has a number of tests for all these cases including
sequences and index on temp tables.
Let me know what you think
Emmanuel
--
Emmanuel Cecchet
FTO @ Frog Thinker
Open Source Development & Consulting
--
Web: http://www.frogthinker.org
email: manu@frogthinker.org
Skype: emmanuel_cecchet