Hi, > I want to port an aplication from PostgreSQL to H2. To prevent users > to overwrite records I use system column > xmin (it's transaction id) to find out if the record was updated > since it was loaded.
I'm sorry, this is not supported by H2. What you can do is use a 'manual' version column, for example like this. This works for all databases: drop table if exists test; create table test(id int, name varchar, version int default 0); insert into test(id, name) values(1, 'Hello'); select * from test; update test set name = 'World', version = version + 1 where id = 1 and version = 0; ... and then check the update count of of this update - if 0 it failed Regards, Thomas --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/h2-database?hl=en -~----------~----~----~----~------~----~------~--~---
