Skip site navigation (1) Skip section navigation (2)

Postgres 8.3.10 Alter Table Waiting issue

From: Pratheeban Jebasingh Tharmaraj <ptharmaraj(at)sirahu(dot)com>
To: pgsql-admin(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org
Subject: Postgres 8.3.10 Alter Table Waiting issue
Date: 2011-06-16 16:30:51
Message-ID: BANLkTikQyR_Mmg9uLmRXfNP4XQC5azG4Hg@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-general
Hi Team,

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

Version of postgres: 8.3.10

Is it known issue or any fix available?


-- 
With Warm Regards,

Pratheeban .T

Responses

pgsql-admin by date

Next:From: Tom LaneDate: 2011-06-16 18:21:40
Subject: Re: alter table without an ACCESS EXCLUSIVE lock
Previous:From: Andreas BergerDate: 2011-06-16 14:55:04
Subject: alter table without an ACCESS EXCLUSIVE lock

pgsql-general by date

Next:From: Joshua BerkusDate: 2011-06-16 16:38:35
Subject: Re: You could be a PostgreSQL Patch Reviewer!
Previous:From: Merlin MoncureDate: 2011-06-16 16:12:09
Subject: Re: PostgreSQL 9.0 or 9.1 ?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group