Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 4E3449FB98B for ; Mon, 14 May 2007 04:00:17 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 11700-10 for ; Mon, 14 May 2007 03:59:53 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from pro33.abac.com (pro33.abac.com [66.226.64.34]) by postgresql.org (Postfix) with ESMTP id 5E9CC9FA220 for ; Mon, 14 May 2007 03:59:55 -0300 (ADT) Received: from ashishk (ppp92-7.vsnl.eth.net [61.17.93.7] (may be forged)) (authenticated bits=0) by pro33.abac.com (8.13.8/8.13.8) with ESMTP id l4E6xfHE070780 (version=TLSv1/SSLv3 cipher=RC4-MD5 bits=128 verify=NO); Sun, 13 May 2007 23:59:45 -0700 (PDT) (envelope-from ashish.karalkar@info-spectrum.com) Message-ID: <010801c795f4$e05bf430$170211ac@LIONKING.COM> From: "Ashish Karalkar" To: "Penchalaiah P." , References: Subject: Re: need help Date: Mon, 14 May 2007 12:25:31 +0530 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0103_01C79622.F67E3830" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.2180 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/102 X-Sequence-Number: 28382 This is a multi-part message in MIME format. ------=_NextPart_000_0103_01C79622.F67E3830 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Anyone else is using this table simulteniously? With Regards Ashish... ----- Original Message -----=20 From: Penchalaiah P.=20 To: pgsql-sql@postgresql.org=20 Sent: Monday, May 14, 2007 12:20 PM Subject: [SQL] need help Hi . Create table cdano_nya(cdano int4,nyano int4) . I created = this table and then I inserted some values to this( 234576,86). =20 =20 Now when I am updating this table .. its not updating = ..query is continuously running. =20 When I am stopping query its giving this message..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.when I am selecting this table in pgAdmin..its strucking the = pgAdmin... =20 Any one can help in this=20 =20 Thanks & Regards Penchal Reddy =20 Information transmitted by this e-mail is proprietary to = Infinite Computer Solutions and / or its Customers and is intended for = use only by the individual or the entity to which it is addressed, and = may contain information that is privileged, confidential or exempt from = disclosure under applicable law. If you are not the intended recipient = or it appears that this mail has been forwarded to you without proper = authority, you are notified that any use or dissemination of this = information in any manner is strictly prohibited. In such cases, please = notify us immediately at info.in@infics.com and delete this email from = your records. =20 ------=_NextPart_000_0103_01C79622.F67E3830 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Anyone else is using this table=20 simulteniously?

With Regards

Ashish...

----- Original Message -----

From:=20 Penchalaiah P.

To: pgsql-sql@postgresql.org =

Sent: Monday, May 14, 2007 = 12:20 PM

Subject: [SQL] need help

Hi = =85

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

= =20 Now when I am updating this table .. its not updating ..query is = continuously=20 running=85

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

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

Any one can help in this =

Thanks = &=20 Regards

Penchal=20 Reddy

Information = transmitted by this=20 e-mail is proprietary to Infinite Computer Solutions and / or = its=20 Customers and is intended for use only by the individual or the = entity=20 to which it is addressed, and may contain information that is=20 privileged, confidential or exempt from disclosure under = applicable law.=20 If you are not the intended recipient or it appears that this = mail has=20 been forwarded to you without proper authority, you are notified = that=20 any use or dissemination of this information in any manner is = strictly=20 prohibited. In such cases, please notify us immediately at=20 info.in@infics.com and delete this email from your=20 = records.

------=_NextPart_000_0103_01C79622.F67E3830--