Re: Alter table never finishes

From: bricklen <bricklen(at)gmail(dot)com>
To: Leonardo M(dot) Ramé <l(dot)rame(at)griensu(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Alter table never finishes
Date: 2013-07-30 17:48:58
Message-ID: CAGrpgQ_9CCMeydzRgm1+6AhLP5TkszutqdrHo-W1DQZxer_==Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Jul 30, 2013 at 10:34 AM, bricklen <bricklen(at)gmail(dot)com> wrote:

> Sorry bricklen, I've killed all idle connections with "kill -9 <PID>",
>
>> then I was able to execute the alter table.
>>
>
> No problem.
>

btw, I meant 'no need to apologize that the queries were gone', not that I
recommend "kill -9" (I don't!)

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Gavin Flower 2013-07-30 19:26:04 Re: How get column-wise table info from an arbitrary query?
Previous Message John R Pierce 2013-07-30 17:46:46 Re: Reddwarf for PostgreSQL?