On 09/04/18 17:52, Sharma, Sreejith wrote:
All,
We are getting below error while creating a table. In the current session no other bulk load has happened.
CREATE TABLE IF NOT EXISTS "SCHEMA_NAME"."TABLE_NAME"
AS
SELECT * FROM " SCHEMA_NAME "."TABLE_NAME" WHERE 1=0;
I don't understand what you're trying to do here. If "SCHEMA_NAME"."TABLE_NAME" exists, this should do nothing, and if it doesn't exist, the SELECT has nothing to select from.
INSERT
INTO "SCHEMA_NAME"."TABLE_NAME"
SELECT * FROM "SCHEMA_NAME"."TABLE_NAME2";
ERROR = !COMMIT: transaction is aborted because of concurrency conflicts, will ROLLBACK instead
~
Also, is there a way to update multiple tables at the same time without above error? Is this due to concurrent insert?
Any help here is much appreciated!
Regards,
Sreejith
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
-- Sjoerd Mullender