Hi, It is not possible to create multiple tables simultaneously , because this causes a transaction conflict on the table sys.tables . If you log the error messages you see !40000!COMMIT: transaction is aborted because of concurrency conflicts, will ROLLBACK instead Pierre De: "Anthony Damico" <ajdamico@gmail.com> À: "Communication channel for MonetDB users" <users-list@monetdb.org> Envoyé: Vendredi 25 Mars 2016 17:28:49 Objet: simultaneously-created tables not generating i have three clients connected to one mserver. they are simultaneously running these three commands, which share table `z` but not the x or y tables-- CREATE TABLE y1 AS SELECT x1.* FROM x1 LEFT JOIN SELECT col FROM Z ON x1.id = z.id WITH DATA ; CREATE TABLE y2 AS SELECT x2.* FROM x2 LEFT JOIN SELECT col FROM Z ON x2.id = z.id WITH DATA ; CREATE TABLE y3 AS SELECT x3.* FROM x3 LEFT JOIN SELECT col FROM Z ON x3.id = z.id WITH DATA ; when all three commands complete, tables y2 and y3 do not exist if i run the commands sequentially, everything works. am i making a mistake in how sql transactions should behave, or is this potentially a bug that i should figure out how to reproduce for bugzilla? thanks! _______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list