Обсуждение: LOCK SEQUENCE

Поиск
Список
Период
Сортировка

LOCK SEQUENCE

От
Mikhail Terekhov
Дата:
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

От
Tom Lane
Дата:
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