Ok I figured it out. I had a prepared transaction holding the locks. The pg_prepared_xacts was helpful. 27-11-2012 10:27, "Marcin Krawczyk" <jankes...@gmail.com> napisaĆ(a):
> Hi list, > > I've got a locking problem which prevents me from doing some alters on my > tables. When I looked into pg_locks I saw a lot of entries (around 1000) > with pid being NULL and almost all of them are AccessShare. Can anyone tell > me what might those be and how do I get rid of them ? >