Re: Alter table command for renaming table is getting stuck.

From: Andreas 'ads' Scherbaum <adsmail(at)wars-nicht(dot)de>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Alter table command for renaming table is getting stuck.
Date: 2009-04-29 08:45:19
Message-ID: 20090429104519.6733ab14@iridium.wars-nicht.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message william pink 2009-04-29 12:36:45 Rather large Postgres directory
Previous Message Robert Ladyman 2009-04-29 07:01:34 Re: Anyone tried storing software users as database users?