On 17 Oct 2016, at 02:01, Luciano Sasso wrote:

Hi,

I am delete rows from table, with "delete from mytable where id=x", and rows deleted no return in select "select * from mytable where id=x", its OK !

Did you run the queries in the autocommit mode or in a transaction? In the later case, did you commit the transaction?

Version "Jul2015-SP1" But, when restart database, deleted rows return in select "select * from mytable where id=x".

Its bug ?, or i have execute vacuum command, how to execute vacuum command. ?

You don’t need to call vacuum to remove tuples from your table. However, the MonetDB version you’re using the pretty old. Please try if you still have this problem with Jun2016-SP2. If your problem persists, please give us reproducible SQL queries, script(s), etc. Regards, Jennie

-- Luciano Sasso Vieira Data Scientist & Solutions Architect

luciano@gsgroup.com.br | tel: 17 3353-0833 | 17 3202-4040 | cel: 17 99706-9335 www.gsgroup.com.br

Este email foi escaneado pelo Avast antivírus. www.avast.com

_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list