Re: Problem with lock? - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: Problem with lock?
Date
Msg-id Pine.LNX.4.44.0309301311080.6281-100000@peter.localdomain
Whole thread Raw
In response to Problem with lock?  (Bjørn T Johansen <btj@havleik.no>)
List 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 by date:

Previous
From: Mike Mascari
Date:
Subject: Functional index performance question
Next
From: Peter Eisentraut
Date:
Subject: Re: pg_hba.conf