Postgres Pro
Downloads
Home   >   mailing lists

Re: Alter table command for renaming table is getting stuck. - Mailing list pgsql-admin

From Andreas 'ads' Scherbaum
Subject Re: Alter table command for renaming table is getting stuck.
Date
Msg-id 20090429104519.6733ab14@iridium.wars-nicht.de
Whole thread Raw
In response to Alter table command for renaming table is getting stuck.  (Dhaval Rami <dhavalrami@gmail.com>)
List pgsql-admin
Tree view 
On Tue, 28 Apr 2009 15:40:22 +0530 Dhaval Rami wrote:

> No other process/query is accessing this table until rotation is done.

Are you sure? Not even VACUUM?

Look into the pg_locks system table to find out, if another connection
is accessing the table.


Kind regards

--
                Andreas 'ads' Scherbaum
German PostgreSQL User Group
European PostgreSQL User Group - Board of Directors

pgsql-admin by date:

Previous
From: Robert Ladyman
Date:
Subject: Re: Anyone tried storing software users as database users?
Next
From: Michael Monnerie
Date:
Subject: Re: CLUSTER not in multi-command string?