Re: [INTERFACES] locking on database updates

Tom Lane wrote:

> Gary Stainburn <gary.stainburn@ringways.co.uk> writes:
> > My question is this.  Is there a safe way of retrieving the next
> > number from the parameter table in such a way that the same number
> > cannot be retrieved twice.
>
> Use a SEQUENCE object for each "parameter table".  This gives you
> a well-tested, efficient generator mechanism.  It may be "auto
> generated" but you do have the option of resetting the sequence's
> nextval and so forth, so I don't see that there is a good reason
> to build a SEQUENCE substitute by hand.
>
>                         regards, tom lane
>
> ************

Can you give an example of sql that creates a table with that?