Hey Vincent, 2011/7/3 Vincent Veyron <vv.li...@wanadoo.fr>
> 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 > > -- // Dmitriy.