Deadlock in Postgres 8.2 - Mailing list pgsql-general

From Sebastjan Trepca
Subject Deadlock in Postgres 8.2
Date
Msg-id cd329af80801201301h3e76b78bie698e890a6a94c28@mail.gmail.com
Whole thread Raw
Responses Re: Deadlock in Postgres 8.2  (Greg Smith <gsmith@gregsmith.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Ivan Sergio Borgonovo
Date:
Subject: setof record "out" syntax and returning records
Next
From: Greg Smith
Date:
Subject: Re: postgresql source build instructions for ubuntu 7.04