Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 9C4039FB1D9 for ; Fri, 2 Feb 2007 02:32:34 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 19041-05 for ; Fri, 2 Feb 2007 02:32:24 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from web33313.mail.mud.yahoo.com (web33313.mail.mud.yahoo.com [68.142.206.128]) by postgresql.org (Postfix) with SMTP id DE1D19FA2B2 for ; Fri, 2 Feb 2007 02:32:25 -0400 (AST) Received: (qmail 98435 invoked by uid 60001); 2 Feb 2007 06:32:21 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=i6jSLFVy8eRe7dSz6dUsmxS7quza9ZVHS4uUem3aoFeN56e5jnNCumWB1BIqkD6REDMAox0X+H6EPNqItBWT142mwjR/6Tz5FK65vp3grIjWA1uAaALgOGhZvNTYsMBcoMeitHUAl0nYqWD39BHdCDANJ5fUOZTNTXspC81U0RM=; X-YMail-OSG: g3KF7EAVM1kwOlaWHRmyPDtatThbkrLMIY_._ArBIq62pu2jrGJ.4MAPLNWfeZivE1t8pGds83xPAgig0iJIZ4tpi_i1PxxGwqr9lNwDEeHFZvTu3ULkwNdTiJDNI3OwDYoHSmPwz7QiQNq8ee1cNRPX0z28aleGV1RvFxBR5z0XBx3AP_95FxZYaa8- Received: from [220.225.70.2] by web33313.mail.mud.yahoo.com via HTTP; Thu, 01 Feb 2007 22:32:21 PST X-Mailer: YahooMailRC/368.3 YahooMailWebService/0.6.132.7 Date: Thu, 1 Feb 2007 22:32:21 -0800 (PST) From: Sandeep Khandelwal Subject: PQputCopyData and Rollback/Commit To: pgsql-interfaces@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Message-ID: <301290.97125.qm@web33313.mail.mud.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=2.906 tagged_above=0 required=5 tests=BAYES_20, DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, DNS_FROM_RFC_WHOIS, FROM_HAS_ULINE_NUMS X-Spam-Level: ** X-Archive-Number: 200702/1 X-Sequence-Number: 6421 Hi All.=0A=0AI am using PQputCopyData function to send data to server one r= ow at a time. When I am done with the data then I call PQputCopyEnd.=0A=0AI= want to do rollback when any error occurs. Please help me how to achieve r= ollback using these functions.=0A=0A=0AThanks, =0ASandeep Khandelwal=0A=0A= =0A =0A____________________________________________________________________= ________________=0ANo need to miss a message. Get email on-the-go =0Awith Y= ahoo! Mail for Mobile. Get started.=0Ahttp://mobile.yahoo.com/mail