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 [EMAIL PROTECTED] ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
