Postgres Pro
Downloads
Home   >   mailing lists

locks problem - Mailing list pgsql-sql

From Marcin Krawczyk
Subject locks problem
Date
Msg-id CABnqL31vYwxK0WAZGwh2BckPfdy9fLbN53RUS9q1sHpVcr8gwg@mail.gmail.com
Whole thread Raw
Responses Re: locks problem  (Marcin Krawczyk <jankes.mk@gmail.com>)
List pgsql-sql
Tree view 
<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 ?

pgsql-sql by date:

Previous
From: Marcin Krawczyk
Date:
Subject: Re: regexp_replace behavior
Next
From: Thomas Kellerer
Date:
Subject: Using regexp_matches in the WHERE clause