LOCK SEQUENCE

Started by Mikhail Terekhovabout 24 years ago2 messages
#1Mikhail Terekhov
terekhov@emc.com

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

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Mikhail Terekhov (#1)
Re: LOCK SEQUENCE

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