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
- Re: [GENERAL] Problem with lock? Bjørn T Johansen
- Re: [GENERAL] Problem with lock? Bjørn T Johansen
- Re: [GENERAL] Problem with lock? Peter Eisentraut