From: | Alban Hertroys <dalroi(at)solfertje(dot)student(dot)utwente(dot)nl> |
---|---|
To: | Pratheeban Jebasingh Tharmaraj <ptharmaraj(at)sirahu(dot)com> |
Cc: | pgsql-admin(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org |
Subject: | Re: [GENERAL] Postgres 8.3.10 Alter Table Waiting issue |
Date: | 2011-06-16 18:30:07 |
Message-ID: | A3EF27C3-F4A8-4A6A-A46C-F70DE55913FD@solfertje.student.utwente.nl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-general |
On 16 Jun 2011, at 18:30, Pratheeban Jebasingh Tharmaraj wrote:
> Hi Team,
>
> I am trying to add column to the table that's hanging.
>
> alter table hr_firms add column_name biginit;
^^^^^^
typo?
> 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?
You have some uncommitted transaction (by the process with pid 1871) on that table that's preventing the database from altering the table. Close that session and it should continue.
Alban Hertroys
--
Screwing up is an excellent way to attach something to the ceiling.
!DSPAM:1268,4dfa4bb512091837758085!
From | Date | Subject | |
---|---|---|---|
Next Message | bakkiya | 2011-06-17 04:29:26 | Re: could not open temporary statistics file "pg_stat_tmp/pgstat.tmp" |
Previous Message | Tom Lane | 2011-06-16 18:21:40 | Re: alter table without an ACCESS EXCLUSIVE lock |
From | Date | Subject | |
---|---|---|---|
Next Message | Greg Smith | 2011-06-16 18:31:03 | Re: Postgres performance and the Linux scheduler |
Previous Message | Alban Hertroys | 2011-06-16 18:21:08 | Re: Constraint to ensure value does NOT exist in another table? |