On Fri, Jan 05, 2007 at 09:30:46 -0800,
Wilton Wonrath <wrwonrath@yahoo.com.br> wrote:
>
> I think that I will need to use LOCK TABLE or SELECT FOR UPDATE, but in
> both cases if the client terminal shutdown suddenly the tuple/table
> stays locked on the server for a indeterminate time.
You need to use LOCK TABLE to block other sessions from concurrently inserting
the same item.
What is the purpose of the number column that requires there to be no gaps
for a particular serie? If they could just be unique, you could use a single
sequence for the table and you wouldn't have to do locking.