Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id C23BE634DAC for ; Wed, 25 Mar 2009 13:49:09 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 12226-08 for ; Wed, 25 Mar 2009 13:49:04 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from depesz.com (depesz.com [78.46.78.198]) by mail.postgresql.org (Postfix) with ESMTP id 9F1A0635B5F for ; Wed, 25 Mar 2009 13:49:03 -0300 (ADT) Received: from depesz by depesz.com with local (Exim 4.69) (envelope-from ) id 1LmWHj-00005y-9J; Wed, 25 Mar 2009 17:48:59 +0100 Date: Wed, 25 Mar 2009 17:48:59 +0100 From: hubert depesz lubaczewski To: Tatsuhito Kasahara Cc: pgsql-hackers@postgresql.org Subject: Re: display previous query string of idle-in-transaction Message-ID: <20090325164859.GB30902@depesz.com> Reply-To: depesz@depesz.com References: <49C9F49B.8020003@oss.ntt.co.jp> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline In-Reply-To: <49C9F49B.8020003@oss.ntt.co.jp> User-Agent: Mutt/1.5.18 (2008-05-17) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200903/997 X-Sequence-Number: 135675 On Wed, Mar 25, 2009 at 06:08:43PM +0900, Tatsuhito Kasahara wrote: > So, I sometimes want to know what query (main cause) was done before > transaction which have been practiced for a long time. > Thoughts? I would love to get it, but when I suggested it some time in the past Tom shot it down as bad idea. http://archives.postgresql.org/message-id/20071016132131.GA4438@depesz.com To be honest - I have yet to see case described by Ton (commit; begin;). Best regards, depesz -- Linkedin: http://www.linkedin.com/in/depesz / blog: http://www.depesz.com/ jid/gtalk: depesz@depesz.com / aim:depeszhdl / skype:depesz_hdl / gg:6749007