Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mUpp6-0000ly-G5 for pgsql-bugs@arkaria.postgresql.org; Mon, 27 Sep 2021 12:33:32 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mUpp4-0005rU-PW for pgsql-bugs@arkaria.postgresql.org; Mon, 27 Sep 2021 12:33:30 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mUpp4-0005rM-Hb for pgsql-bugs@lists.postgresql.org; Mon, 27 Sep 2021 12:33:30 +0000 Received: from wout4-smtp.messagingengine.com ([64.147.123.20]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mUpp2-00076Q-45 for pgsql-bugs@postgresql.org; Mon, 27 Sep 2021 12:33:29 +0000 Received: from compute6.internal (compute6.nyi.internal [10.202.2.46]) by mailout.west.internal (Postfix) with ESMTP id 04E533200E5D; Mon, 27 Sep 2021 08:33:26 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute6.internal (MEProxy); Mon, 27 Sep 2021 08:33:27 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-transfer-encoding:content-type :date:from:in-reply-to:message-id:mime-version:subject:to :x-me-proxy:x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s= fm3; bh=ARU3dJX8V/SmKWjkhtFnW9++79aFyqb5Wfcf9vjTX0Y=; b=UxBKnO2q MWG+4f+xo6o1/a+CSlHHyJaOr7W77B/iqdo0X9XUFRDIJ+rvYYjTTmWzzNHMvJEY chJfKHWkMBsitXqUVhCVVM6cSYkIVSZISsuEUvv0emQOpSk5mg43e+UFkSPnBx0m F2knuEi+rATKxkOOs24pEgIaPrCd/pfZYhE19/WaLNQxRRaDVrNeL9r7aE4KrFvp SI7mBqN7RCRm4T1b6KTXPOBW7Tv6BajHK67Q7ISXNdZOcJhqBIpvLOqxL1MdFKDN waLpCmgzsH3wC7Hv3QJYCZ4J5PgEedaY1GT2Wm0PEZGLLsuQ+5c8F19gsNlWAJkf C+qOxicKPPyx3A== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvtddrudejkedghedvucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne cujfgurhepfffhvffukfggtggugfgjsehtkeertddttdejnecuhfhrohhmpeetlhhvrghr ohcujfgvrhhrvghrrgcuoegrlhhvhhgvrhhrvgesrghlvhhhrdhnohdqihhprdhorhhgqe enucggtffrrghtthgvrhhnpedujeevjeffjeevuddutedvkeeiueeitddvieelfeekveej udefgeeuvdejhfeuleenucffohhmrghinhepvghnthgvrhhprhhishgvuggsrdgtohhmne cuvehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehmrghilhhfrhhomheprghlvhhh vghrrhgvsegrlhhvhhdrnhhoqdhiphdrohhrgh X-ME-Proxy: Received: by mail.messagingengine.com (Postfix) with ESMTPA; Mon, 27 Sep 2021 08:33:26 -0400 (EDT) Received: by perhan.alvh.no-ip.org (Postfix, from userid 1000) id 3C1AA2A0677; Mon, 27 Sep 2021 09:33:23 -0300 (-03) Date: Mon, 27 Sep 2021 09:33:23 -0300 From: Alvaro Herrera To: Heikki Linnakangas Cc: Pg Bugs , Andrew B Subject: Re: Snapshot leak warning with lo_export in subtransaction Message-ID: <202109271233.5zn5bqxn657w@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <32bf767a-2d65-71c4-f170-122f416bab7e@iki.fi> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 2021-Sep-27, Heikki Linnakangas wrote: > This should be backpatched to all supported versions. This adds an argument > to 'inv_open' function, but I don't think there are extensions that use the > inv_*() functions directly. inv_api.c relies on close_lo_relation() being > called at the end of transaction, so I think an extension would find it hard > to use those functions correctly, anyway. Hmm, but you could also use a new value in its existing 'flags' argument instead of changing ABI. -- Álvaro Herrera PostgreSQL Developer — https://www.EnterpriseDB.com/ Voy a acabar con todos los humanos / con los humanos yo acabaré voy a acabar con todos (bis) / con todos los humanos acabaré ¡acabaré! (Bender)