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.