Re: Problem with lock?

Поиск
Список
Период
Сортировка
От Bjørn T Johansen
Тема Re: Problem with lock?
Дата
Msg-id 1064918629.20427.34.camel@dt-btj.dagbladet.no
обсуждение исходный текст
Ответ на Problem with lock?  (Bjørn T Johansen <btj@havleik.no>)
Список pgsql-general
It looks like it was a one time happening... I restarted the database
and then tried again and then it all worked like a charm.... Hmmm....

BTJ

On Tue, 2003-09-30 at 12:33, Bjørn T Johansen wrote:
> 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?
>
>
> Regards,
>
> BTJ


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

Предыдущее
От: Bjørn T Johansen
Дата:
Сообщение: Problem with lock?
Следующее
От: Mike Mascari
Дата:
Сообщение: Functional index performance question