Also a small addition to CREATE TABLE documentation would be nice.
Does TEMP mean
1) LOCAL TEMPORARY
or
2) GLOBAL TEMPORARY

- Rami


On 19.1.2015 15:37, Rami Ojares wrote:
Hi,

This is a feature request.

Temporary tables are good for breaking a complex query to more manageable pieces. And when marking the create statement as TRANSACTIONAL you can use them also in triggers. But my problem is that such tables need to be recreated for example everytime a function is invoked.
And unfortunately dropping a table always commits a transaction.
Therefore the TRANSACTIONAL marker is of no use because you can not delete/recreate the table in a trigger.

There are 2 ways to fix this.
1) Add TRANSACTIONAL to DROP TABLE
or
2) Add OR REPLACE to CREATE TABLE (CREATE VIEW has this)

- Rami

--
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.

Reply via email to