locks problem

From: Marcin Krawczyk <jankes(dot)mk(at)gmail(dot)com>
To: "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org>
Subject: locks problem
Date: 2012-11-27 09:27:10
Message-ID: CABnqL31vYwxK0WAZGwh2BckPfdy9fLbN53RUS9q1sHpVcr8gwg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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 ?

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message ssylla 2012-11-27 09:59:54 output query on many to many relationship into several columns
Previous Message Thomas Kellerer 2012-11-26 12:13:06 Using regexp_matches in the WHERE clause