2011/7/3 Vincent Veyron <vv.lists@xxxxxxxxxx>
Le vendredi 01 juillet 2011 à 12:28 +0400, Dmitriy Igrishin a écrit :
Chris already explained why twice :
> 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...
>
"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?
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
--
// Dmitriy.
