Le vendredi 01 juillet 2011 à 12:28 +0400, Dmitriy Igrishin a écrit :
> Then I don't clearly understand the existence of locks (the LOCK > command, SELECT FOR UPDATE clause and so on) if the usage > of them gives only problems... >
Chris already explained why twice :
"you MUST lock on insert to get gapless sequences"
Not me :-). The OP must do it. So, what problem here? Deadlocks? Again, if deadlocks are so dangerous, why the LOCK command exists?
Can't you just : -create the records with a regular sequence, that will have gaps -when you want to export, number an additional column from 1 to 10 000 and use that as key ?
I don't use any locks explicitly :-)
-- Vincent Veyron http://marica.fr/ Logiciel de gestion des sinistres et des contentieux pour le service juridique