Hi, I am a new postresql user, but have done a lock of work with Oracle. I am having a familiar problem with stale locks. I try to drop a table in psql but the transaction hangs. I can abort the transaction with Ctl-C, but it will never succeed.
My first instinct was a stale lock so I look in pg_locks and sure enough a lock exists. Now the question is, how do I free this lock? This is just a single machine installation and there are no processes running that could hold the lock. I suspect it is from a process that crashed. Under Oracle we used to just kill the pid that held the lock and the DB cleaned everything up. When I tried that under postgresql my database crashed. Obviously the PID column in the pg_locks table is for the server process, not the client process :-(. How do people normally deal with this type of problem? Thanks, Chris. -- [EMAIL PROTECTED] www.networkchemistry.com ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
