Message-Id: <4DFB167A020000250003E7C2@gw.wicourts.gov>
Date: Fri, 17 Jun 2011 08:55:22 -0500
From: "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
To: <pgsql-admin@postgresql.org>,<pgsql-general@postgresql.org>,
	<ptharmaraj@sirahu.com>
Subject: Re: Postgres 8.3.10 Alter Table Waiting issue
References: <4DFB154B020000250003E7B8@gw.wicourts.gov>
	<4DFB167A020000250003E7C2@gw.wicourts.gov>
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

[please don't send a post to multiple lists]
 
Pratheeban Jebasingh Tharmaraj <ptharmaraj@sirahu.com> wrote:
 
> I am trying to add column to the table that's hanging.
> 
> alter table hr_firms add column_name biginit;
> 
> This is the lock I see in the db
> 
>  relation      |   564709 | 586888   |      |       |            |
>     |         |       |          | 1/8                | 1871 |
> AccessExclusiveLock | f
 
So it's temporarily blocking, waiting for conflicting access to
complete.
 
> Is it known issue or any fix available?
 
Don't modify the structure of the table at the same time as
conflicting access against the table, or wait for the transactions
performing the conflicting access to commit?
 
You haven't described the other activity on the table or shown the
other lock(s) involved in the blocking.  Without more information,
it's hard to be more specific.
 
http://wiki.postgresql.org/wiki/Guide_to_reporting_problems
 
-Kevin