[SQL] locks problem

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 ?

Re: [SQL] locks problem

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