Thread: locks problem

<p>Hi list,<p>I've got a locking problem which prevents me from doing some alters on my tables. When I looked into
pg_locksI saw a lot of entries (around 1000) with pid being NULL and almost all of them are AccessShare. Can anyone
tellme what might those be and how do I get rid of them ? 

<p>Ok I figured it out. I had a prepared transaction holding the locks. The pg_prepared_xacts was helpful.<div
class="gmail_quote">27-11-201210:27, "Marcin Krawczyk" <<a
href="mailto:jankes.mk@gmail.com">jankes.mk@gmail.com</a>>napisał(a):<br type="attribution" /><blockquote
class="gmail_quote"style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><p>Hi list,<p>I've got a
lockingproblem 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
andhow do I get rid of them ?</blockquote></div>