Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id CB0EF9FB274 for ; Mon, 14 May 2007 15:40:34 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 23287-04 for ; Mon, 14 May 2007 15:40:30 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from an-out-0708.google.com (an-out-0708.google.com [209.85.132.250]) by postgresql.org (Postfix) with ESMTP id 7E9349FB1D4 for ; Mon, 14 May 2007 15:40:30 -0300 (ADT) Received: by an-out-0708.google.com with SMTP id d17so437500and for ; Mon, 14 May 2007 11:40:29 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:sender:to:subject:cc:in-reply-to:mime-version:content-type:references:x-google-sender-auth; b=L736VfnBZ+cjCYqk7fig95G3RHyd/3eP6InixOSpVER6kW6ugPPjNtoX3Ulc/IQSdI7RYDGpH/LkjJKdi2jYNtw+rPUgPtabPCje69rSbQCKvFdzvRU1HgIlpKQN2s+uv6rBKgxH38IEvsk1wQOXlDH0Gc4qOljeLYdZo2mXI1U= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:sender:to:subject:cc:in-reply-to:mime-version:content-type:references:x-google-sender-auth; b=WEzccQZK7nbNmrIZGtK6P8WofLBPnWyg7OjaZYbl9iPgcI8Bd1wotSg+RaLSYFeUdjUmE02mCNR81VH8YJpRKIGe9h9jl2IJpzTj5kwJ+Pt4GPwahMN3i4sVEB9YxWweEihhIYW1YSLm5uWwCe4uCr2cridAmgowkrREgadN6ZE= Received: by 10.100.173.19 with SMTP id v19mr4787272ane.1179168028756; Mon, 14 May 2007 11:40:28 -0700 (PDT) Received: by 10.100.144.18 with HTTP; Mon, 14 May 2007 11:40:28 -0700 (PDT) Message-ID: Date: Mon, 14 May 2007 13:40:28 -0500 From: "Aaron Bono" To: "Penchalaiah P." Subject: Re: need help Cc: pgsql-sql@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_227403_5765678.1179168028599" References: X-Google-Sender-Auth: 16255819779f20f4 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/108 X-Sequence-Number: 28388 ------=_Part_227403_5765678.1179168028599 Content-Type: text/plain; charset=WINDOWS-1252; format=flowed Content-Transfer-Encoding: quoted-printable Content-Disposition: inline On 5/14/07, Penchalaiah P. wrote: > > Hi =85 > > Create table cdano_nya(cdano int4,nyano int4) =85 I created t= his > table and then I inserted some values to this( 234576,86)=85 > > > > Now when I am updating this table .. its not updating ..query > is continuously running=85 > > > > When I am stopping query its giving this message=85.ERROR: > canceling statement due to user request.. > > May I know the reason y its not running.. and I am unable to drop this > table also=85when I am selecting this table in pgAdmin..its strucking the > pgAdmin=85.. > > > > Any one can help in this > > What does your query look like? Are you using locking or transactions wher= e other queries are blocking your query from running? -Aaron --=20 =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D Aaron Bono Aranya Software Technologies, Inc. http://www.aranya.com http://codeelixir.com =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D ------=_Part_227403_5765678.1179168028599 Content-Type: text/html; charset=WINDOWS-1252 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline On 5/14/07, Penchalaiah P. <penchalaiahp@infics.com> wrote:

Hi =85

          &n= bsp; Create table cdano_nya(cdano int4,nyano int4) =85 I created this table and then I inserted some values to this( 234576,86)=85=     

 

          &n= bsp; Now when I am updating this table .. its not updating ..query is continuously running=85

 

          &n= bsp; When I am stopping query its giving this message=85.ERROR:  canceling statement due to user request..

May I know the reason y its not running.. and I am unable to drop this table also=85when I am selecting this table in pgAdmin..its strucking the pgAdmin=85..

 

Any one can help in this

<= tbody>


What does your = query look like?  Are you using locking or transactions where other qu= eries are blocking your query from running?

-Aaron
=
--
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
   A= aron Bono
   Aranya Software Technologies, Inc.
  = ; http://www.aranya.com
 &nbs= p; http://codeelixir.com
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D ------=_Part_227403_5765678.1179168028599--