On Nov 27, 2007, at 9:47 PM, Igor Sereda wrote:

I noticed that CREATE TABLE works well within a transaction, which was a pleasant surprise. I can create a table and insert some rows in it, all quite ACIDly - wow!

My question is, is that a declared contract or just a peculiarity that may disappear in future versions? I couldn't find any specs of that behavior in documentation. If I missed it, please point me to the URL. If there are no mentions of that in docs, well, it's probably worth mentioning.

It's a supported feature.

Also, which statements are not transactional? VACUUM is obviously one of them, are there any other?

Some of the pragma statements. Can't think of anything else.

Dan.


-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------

Reply via email to