Re: How to create "auto-increment" field WITHOUT a sequence object?

Hey Vincent,

2011/7/3 Vincent Veyron <vv(dot)lists(at)wanadoo(dot)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.