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

Re: Problem with lock?

From: Bjørn T Johansen <btj(at)havleik(dot)no>
To: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Problem with lock?
Date: 2003-09-30 10:43:50
Message-ID: 1064918629.20427.34.camel@dt-btj.dagbladet.no (view raw or flat)
Thread:
Lists: 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


In response to

pgsql-general by date

Next:From: Mike MascariDate: 2003-09-30 11:06:49
Subject: Functional index performance question
Previous:From: Bjørn T JohansenDate: 2003-09-30 10:33:31
Subject: Problem with lock?

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