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....
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?
In response to
pgsql-general by date
|Next:||From: Mike Mascari||Date: 2003-09-30 11:06:49|
|Subject: Functional index performance question|
|Previous:||From: Bjørn T Johansen||Date: 2003-09-30 10:33:31|
|Subject: Problem with lock?|