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

Niels Nes Niels.Nes at cwi.nl
Sat Jan 5 20:13:25 CET 2008


On Sat, Jan 05, 2008 at 07:35:58PM +0100, Romulo Goncalves wrote:
> 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?
on commit actions are only defined for temporary tables! This is a sql
specification. Afcourse we could allow it and simply see persistent
tables + commit action as global temps.

Niels
> 
> Regards,
> Romulo
> 
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2005.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________
> Monetdb-developers mailing list
> Monetdb-developers at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/monetdb-developers

-- 

Niels Nes, Centre for Mathematics and Computer Science (CWI)
Kruislaan 413, 1098 SJ Amsterdam, The Netherlands
room C0.02,  phone ++31 20 592-4098, fax ++31 20 592-4312
url: http://www.cwi.nl/~niels   e-mail: Niels.Nes at cwi.nl




More information about the developers-list mailing list