subject:"\[ADMIN\] Postgres 8.3.10 Alter Table Waiting issue"

Re: [ADMIN] Postgres 8.3.10 Alter Table Waiting issue

2011-06-17 Thread Kevin Grittner

[please don't send a post to multiple lists] Pratheeban Jebasingh Tharmaraj 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 | | |

[ADMIN] Postgres 8.3.10 Alter Table Waiting issue

2011-06-16 Thread Pratheeban Jebasingh Tharmaraj

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 |