Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 3F776B5DBC4 for ; Mon, 3 Oct 2011 13:56:58 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 50768-03 for ; Mon, 3 Oct 2011 16:56:52 +0000 (UTC) X-Greylist: delayed 00:06:38.910206 by SQLgrey-1.8.0-rc2 Received: from mail.csc.lt (mail.csc.lt [193.138.191.5]) by mail.postgresql.org (Postfix) with ESMTP id 57395B5DBC0 for ; Mon, 3 Oct 2011 13:56:51 -0300 (ADT) Received: (qmail 28688 invoked by uid 210); 3 Oct 2011 16:50:09 -0000 Received: from mail.nsoft.lt by mail (envelope-from , uid 201) with qmail-scanner-2.05st (clamdscan: 0.97/13729. spamassassin: 3.2.1. perlscan: 2.05st. Clear:RC:1(77.240.249.53):. Processed in 0.010753 secs); 03 Oct 2011 16:50:09 -0000 Received: from mail.nsoft.lt (77.240.249.53) by mail.csc.lt with SMTP; 3 Oct 2011 16:50:09 -0000 Received: from [192.168.16.113] (unknown [77.240.249.53]) (using TLSv1 with cipher DHE-RSA-CAMELLIA256-SHA (256/256 bits)) (No client certificate requested) by mail.nsoft.lt (Postfix) with ESMTPS id A91308E34B for ; Mon, 3 Oct 2011 19:50:07 +0300 (EEST) Message-ID: <4E89E7BF.9040009@nsoft.lt> Date: Mon, 03 Oct 2011 19:50:07 +0300 From: Julius Tuskenis Organization: UAB nSoft User-Agent: Mozilla/5.0 (Windows NT 5.1; rv:7.0.1) Gecko/20110929 Thunderbird/7.0.1 MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: commiting transaction from outside Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201110/3 X-Sequence-Number: 38455 Hello, my question my sound strange, but because of a bug in an application I see the transaction was started and not commited (connection state is IDLE in transaction). Is there a way to commit this transaction? I don't want to loose data. I think if I close the application the transaction would get rollbacked. I've tried google'ing but without results - this might mean, that there is no way, but I thought asking is an option.. Thank you in advance for any advice. -- Julius Tuskenis Programavimo skyriaus vadovas UAB nSoft mob. +37068233050