Re: Problem with lock?

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: Problem with lock?
Дата
Msg-id Pine.LNX.4.44.0309301311080.6281-100000@peter.localdomain
обсуждение исходный текст
Ответ на Problem with lock?  (Bjørn T Johansen <btj@havleik.no>)
Список pgsql-general
Bjørn T Johansen writes:

> I run the following SQL before updating one table:
>
> "lock table tablename"
>
> but when I try do update the same table later on, the lock table command
> just hangs (i.e the table is already locked).
> It was my understanding that this lock was removed when I call commit or
> do I have to explicitly unlock the table somehow?

Show us what commands you are running, in what sequence, how many
sessions, etc.

--
Peter Eisentraut   peter_e@gmx.net


В списке pgsql-general по дате отправления:

Предыдущее
От: Mike Mascari
Дата:
Сообщение: Functional index performance question
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: pg_hba.conf