Alter table never finishes

From: Leonardo M(dot) Ramé <l(dot)rame(at)griensu(dot)com>
To: PostgreSql-general <pgsql-general(at)postgresql(dot)org>
Subject: Alter table never finishes
Date: 2013-07-30 14:50:02
Message-ID: 20130730145002.GI5552@leonardo-laptop
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi, I need to do an alter table on a small table (~300 records), but it
never ends. It may be because there are clients using that table.

How can I force disconnect all clients to let me alter that table?.

Regards,
--
Leonardo M. Ramé
Medical IT - Griensu S.A.
Av. Colón 636 - Piso 8 Of. A
X5000EPT -- Córdoba
Tel.: +54(351)4246924 +54(351)4247788 +54(351)4247979 int. 19
Cel.: +54 9 351 6629292

Responses

Browse pgsql-general by date

  From Date Subject
Next Message bricklen 2013-07-30 15:13:20 Re: Fwd: corrupted files
Previous Message Adrian Klaver 2013-07-30 14:42:40 Re: to_char with locale decimal separator