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" 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 ? -- Vincent Veyron http://marica.fr/ Logiciel de gestion des sinistres et des contentieux pour le service juridique -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
