Re: [GENERAL] How to unlock a row

2006-12-29 Thread Jerry Sievers
"vinjvinj" <[EMAIL PROTECTED]> writes: > One of my updates is hanging on a postgres table. I'm guessing if the > table or row is locked. > > Questions: > > 1. What table can I select from to find the lock? > 2. How do I clear the lock? 1pg_locks view, perhaps joined with pg_class and pg_stat_ac

Re: [GENERAL] How to unlock a row

2006-12-29 Thread vinjvinj
> 1. What table can I select from to find the lock? pg_locks shows no rows returned. But the update still hangs. VJ ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings