Skip site navigation (1) Skip section navigation (2)

Re: Problem with lock?

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Bjørn T Johansen <btj(at)havleik(dot)no>
Cc: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Problem with lock?
Date: 2003-09-30 11:11:57
Message-ID: Pine.LNX.4.44.0309301311080.6281-100000@peter.localdomain (view raw or flat)
Thread:
Lists: 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(at)gmx(dot)net


In response to

pgsql-general by date

Next:From: John K. HerreshoffDate: 2003-09-30 11:21:35
Subject: Re: FUD!! ODBC will not be supported by Microsoft in the future
Previous:From: Mike MascariDate: 2003-09-30 11:06:49
Subject: Functional index performance question

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group