Is there some kind of log, table or something that I could get more information about a deadlock situation that is occurring in my database? I just get a transaction number and a process id, which is useless to me because my application terminates on any errors from the database? It occurs infrequently (about once a day) and I have no idea how to track it down. Also sometimes the database just freezes (RedHat EL 3.0 Postgresql 8.0.1) could this be a deadlock situation? There is nothing in the log about deadlock or anything else when it freezes (this happens about once every month or so)
Thanks, Bart ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
