Re: [MonetDB-users] MonetDB-SQL 2.10.0 - Status of temorary tables?

Hi Fabien, On Tue, 31 Jan 2006 10:08:07 +0100 Fabian Groffen wrote:

Is this within a transaction or not?

Does this work for example:

START TRANSACTION;

CREATE LOCAL TEMPORARY TABLE foo (abc integer); INSERT INTO foo VALUES(1); INSERT INTO foo VALUES(2); SELECT * FROM foo;

COMMIT;

Yes, this works. However I'm evaluating monetdb for use in an interactive application and a long running transaction to support the GUI wouldn't work as it would preclude other transactions on that connection. Lee