Problem with lock?

From: Bjørn T Johansen <btj(at)havleik(dot)no>
To: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Problem with lock?
Date: 2003-09-30 10:33:31
Message-ID: 1064918010.20427.31.camel@dt-btj.dagbladet.no
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bjørn T Johansen 2003-09-30 10:43:50 Re: Problem with lock?
Previous Message strk 2003-09-30 10:21:30 Re: [postgis-users] Union as an aggregate