Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1h4fEx-0006Tz-P9 for pgsql-hackers@arkaria.postgresql.org; Fri, 15 Mar 2019 05:18:44 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1h4fEw-0000on-6z for pgsql-hackers@arkaria.postgresql.org; Fri, 15 Mar 2019 05:18:42 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1h4fEv-0000ZM-ER for pgsql-hackers@lists.postgresql.org; Fri, 15 Mar 2019 05:18:41 +0000 Received: from anastigmatix.net ([68.171.219.55]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1h4fEs-0004ST-Iw for pgsql-hackers@postgresql.org; Fri, 15 Mar 2019 05:18:40 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=anastigmatix.net; s=default; h=Content-Transfer-Encoding:Content-Type: MIME-Version:Date:Message-ID:Subject:From:To:Sender:Reply-To:Cc:Content-ID: Content-Description:Resent-Date:Resent-From:Resent-Sender:Resent-To:Resent-Cc :Resent-Message-ID:In-Reply-To:References:List-Id:List-Help:List-Unsubscribe: List-Subscribe:List-Post:List-Owner:List-Archive; bh=v88awi8nQxkzIqSrKOCWJMoVuPyFXCvigvdt8vgutpI=; b=PygrpEZxbPd4ROe1i8MOs2+aRv maNuR12nxJChLO6luQufITpU50E/2gS+fppRfawIW4LzVXTDgvYu6uc8uLn7t7tNj+HsiDQjvXZBV Cz92MwagCjT6nRqakCVD53LWfVzIywAeuWT+hJgsBpICPOPpy/tkDeaeM2s6ngccNaktQEHfuZqX3 /IlipDufobjiRFOaTvuLE1NfupsXVa7XH1td0JT4gFk5UZrSPmlcB5005ouQwDbkjyZc4WsCVBVn2 XuBD2fIzRSwAvqwQNFuaeud07YTXH+8n0HOElXko0I3pGOz35VtZv9ZNUpmU+Ytax3ZbzIUoSfZb1 5QjT6zoQ==; Received: from [184.19.63.78] (port=44781) by bay.acenet.us with esmtpsa (TLSv1.2:ECDHE-RSA-AES128-GCM-SHA256:128) (Exim 4.91) (envelope-from ) id 1h4fEi-001TUr-Ki for pgsql-hackers@postgresql.org; Fri, 15 Mar 2019 01:18:37 -0400 To: PostgreSQL Hackers From: Chapman Flack Subject: What is a savepointLevel ? X-Enigmail-Draft-Status: N1110 Message-ID: <5C8B35A4.5000404@anastigmatix.net> Date: Fri, 15 Mar 2019 01:18:28 -0400 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:38.0) Gecko/20100101 Thunderbird/38.7.0 MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-OutGoing-Spam-Status: No, score=-99.5 X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - bay.acenet.us X-AntiAbuse: Original Domain - postgresql.org X-AntiAbuse: Originator/Caller UID/GID - [47 12] / [47 12] X-AntiAbuse: Sender Address Domain - anastigmatix.net X-Get-Message-Sender-Via: bay.acenet.us: authenticated_id: chap@anastigmatix.net X-Authenticated-Sender: bay.acenet.us: chap@anastigmatix.net X-Source: X-Source-Args: X-Source-Dir: X-From-Rewrite: unmodified, already matched List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Hello hackers, What exactly is a savepointLevel? They seem to have been there for 15 years[1], diligently copied from parent transactions to children, fastidiously checked to avoid crossing a level on rollback or release, but does anything ever change the level from its initial value? I'm drawing a blank[2]. Regards, -Chap [1] https://git.postgresql.org/gitweb/?p=postgresql.git;a=blame;f=src/backend/access/transam/xact.c;h=fd5d6b5;hb=90cb9c3#l93 [2] https://git.postgresql.org/gitweb/?p=postgresql.git&a=search&h=0516c61b&st=grep&s=savepointLevel