Hi, we are spotting constant deadlocks when altering tables. After I restart the db the ALTER TABLE command runs without problems, but when I try to alter some other table later on it deadlocks again. If I kill the process that handles ALTER TABLE the deadlock is "unlocked", but ALTER TABLE still won't run until I restart it. I've checked the logs, but didn't find anything useful. How can I get some more information on what is happening when the server deadlocks? Thanks, Sebastjan ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly