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 ?
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