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
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to
ma*******@postgresql.org)