Thread: LOCK SEQUENCE

LOCK SEQUENCE

From

Mikhail Terekhov

Date:

25 October 2001, 20:08:57

Hi,

In my application I use 'LOCK seq'. In 7.0.2 it worked fine but in
7.1.2 Postgres complains that 'seq is not a table'. Is this
(disabling to lock a sequences) an intended change?

Thanks
Mikhail

Re: LOCK SEQUENCE

From

Tom Lane

Date:

25 October 2001, 20:41:19

Mikhail Terekhov <terekhov@emc.com> writes:
> In my application I use 'LOCK seq'. In 7.0.2 it worked fine but in
> 7.1.2 Postgres complains that 'seq is not a table'. Is this
> (disabling to lock a sequences) an intended change?

Hmm, it wasn't thought about too much, but why in the world would you
want to lock a sequence?  Seems like that destroys the point of using
one.
        regards, tom lane