Hi Anthony,
On 22/02/13 19:44, Anthony Damico wrote:
Hi, I am using a brand new mserver.exe instance of MonetDB5 on Windows. I am getting the error: "COMMIT: transaction is aborted because of concurency conflicts, will ROLLBACK instead" that I'm not sure I should? Shouldn't I be able to use the COPY command on two separate CSV files into two separate data tables at once? I don't think this behavior is correct, but maybe I'm wrong? :/
You can do that, but not with the LOCKED keyword. That says basically, that the COPY INTO is the only thing happening on the DB at that time and that it can forget about all the transactional stuff. Once you are doing two such things, it gets messy. So, either only run one COPY statement or remove LOCKED.
Best,
Hannes (who is still at work writing a paper... you are mentioned in the Acknowledgements!)