Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125]) by mail.postgresql.org (Postfix) with ESMTP id 57D3E16B0CAD for ; Mon, 19 Dec 2011 15:44:14 -0400 (AST) Received: from 30.55.colo.spiretech.net ([69.168.55.30] helo=lists.commandprompt.com) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1Rcj86-0007VP-6q for pgsql-hackers@postgresql.org; Mon, 19 Dec 2011 19:44:14 +0000 Received: from perhan.alvh.no-ip.org (spinlock.commandprompt.com [69.168.55.30]) by lists.commandprompt.com (Postfix) with ESMTPA id D6FB6282; Mon, 19 Dec 2011 11:44:03 -0800 (PST) Received: from perhan.alvh.no-ip.org ([200.126.85.47] helo=perhan.alvh.no-ip.org) by assp.commandprompt.com with ESMTPS(AES256-SHA) (2.1.1); 19 Dec 2011 11:44:01 -0800 Received: by perhan.alvh.no-ip.org (Postfix, from userid 1000) id 0E5556E41D; Mon, 19 Dec 2011 16:43:52 -0300 (CLST) Content-Type: text/plain; charset=UTF-8 Cc: Simon Riggs , Gianni Ciolli , Pg Hackers Subject: Re: Autonomous subtransactions From: Alvaro Herrera To: Marti Raudsepp In-reply-to: References: <20111218082812.GA14355@leggeri.gi.lan> Date: Mon, 19 Dec 2011 16:43:51 -0300 Message-Id: <1324323767-sup-485@alvh.no-ip.org> User-Agent: Sup/git X-Assp-Version: 2.1.1(11278) on assp.commandprompt.com X-Assp-Client-TLS: yes X-Assp-ID: assp.commandprompt.com m1-23843-06932 X-Assp-Envelope-From: alvherre@alvh.no-ip.org X-Assp-Intended-For: simon@2ndquadrant.com X-Assp-Original-Subject: Re: [HACKERS] Autonomous subtransactions Content-Transfer-Encoding: quoted-printable X-Pg-Spam-Score: 0.3 (/) X-Archive-Number: 201112/916 X-Sequence-Number: 200168 Excerpts from Marti Raudsepp's message of lun dic 19 16:32:06 -0300 2011: > (I do realize that allowing subtransactions to commit out of order > also makes it failure prone) Uhm? You can't "commit" savepoints out of order. You can "release" an older one, but then all the ones following it disappear and can't be released separately. --=20 =C3=81lvaro Herrera The PostgreSQL Company - Command Prompt, Inc. PostgreSQL Replication, Consulting, Custom Development, 24x7 support