[Monetdb-developers] commit options for create table statement....

Romulo Goncalves R.A.Goncalves at cwi.nl
Sat Jan 5 19:35:58 CET 2008


Reading the MonetDB code seems that commit option
ON COMMIT DROP
ON COMMIT PRESERVE ROWS
ON COMMIT DELETE ROWS

should not be used for normal tables (the ones which are not temporary). 
If that is the rule, the commit option should be allowed in the create 
table statement.
If it is not the rule, the commit option is not being used at all for 
the normal tables.

Look to the following example (auto-commit mode is on):
 >CREATE TABLE test1(id int) ON COMMIT DELETE ROWS;
&3
 >insert into test1 values(1);
&2 1 -1
 >select * from test1;
&1 3 1 1 1
% sys.test1 # table_name
% id # name
% int # type
% 1 # length
[ 1     ]
 >

So what is the rule for MonetDB?

Regards,
Romulo




More information about the developers-list mailing list