Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id A92D79FB5F5 for ; Mon, 14 May 2007 03:50:29 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 82247-07 for ; Mon, 14 May 2007 03:50:25 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from gateway.infics.com (gateway.infics.com [202.54.39.20]) by postgresql.org (Postfix) with ESMTP id 3DD839FB212 for ; Mon, 14 May 2007 03:50:19 -0300 (ADT) X-MimeOLE: Produced By Microsoft Exchange V6.5.7226.0 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C795F4.21897FF8" Subject: need help Date: Mon, 14 May 2007 12:20:16 +0530 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: need help Thread-Index: AceV9CEayB+cCozZStCmLsq1hA7AXA== From: "Penchalaiah P." To: X-imss-version: 2.046 X-imss-result: Passed X-imss-scanInfo: M:B L:E SM:3 X-imss-tmaseResult: TT:1 TS:-15.0564 TC:1F TRN:62 TV:3.6.1039(15170.001) X-imss-scores: Clean:69.65586 C:2 M:3 S:5 R:5 X-imss-settings: Baseline:3 C:4 M:4 S:4 R:4 (0.5000 0.5000) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/100 X-Sequence-Number: 28380 This is a multi-part message in MIME format. ------_=_NextPart_001_01C795F4.21897FF8 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Hi ... Create table cdano_nya(cdano int4,nyano int4) ... I created this table and then I inserted some values to this( 234576,86)... =0D =0D Now when I am updating this table .. its not updating ..query is continuously running... =0D 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..... =0D Any one can help in this=0D =0D Thanks & Regards Penchal Reddy =0D 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. ------_=_NextPart_001_01C795F4.21897FF8 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hi …

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

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

&n= bsp; 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…..

Any one can help in this

Thanks &= Regards

Penchal= Reddy

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.

------_=_NextPart_001_01C795F4.21897FF8--