Re: Error while dropping a table - Mailing list pgsql-general

From Andrew Sullivan
Subject Re: Error while dropping a table
Date
Msg-id 20020725143640.W29680@mail.libertyrms.com
Whole thread Raw
In response to Re: Error while dropping a table  ("Johnson, Shaunn" <SJohnson6@bcbsm.com>)
List pgsql-general
On Thu, Jul 25, 2002 at 02:04:56PM -0400, Johnson, Shaunn wrote:
>
> --Okay, but now, how do I find out what client is holding
> --the table hostage?  Generally, I would do something like

ps -auxww and look for something "idle in transaction" that's been
running a long time.

A

--
----
Andrew Sullivan                               87 Mowat Avenue
Liberty RMS                           Toronto, Ontario Canada
<andrew@libertyrms.info>                              M6K 3E3
                                         +1 416 646 3304 x110


pgsql-general by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: Migrating database (7.1.3 - 7.2.1)
Next
From: robert kraus
Date:
Subject: pivoting, crosstabbing and almost there !