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 1pbksf-0004LD-1p for pgsql-general@arkaria.postgresql.org; Mon, 13 Mar 2023 16:18:37 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pbksd-0000BU-O0 for pgsql-general@arkaria.postgresql.org; Mon, 13 Mar 2023 16:18:35 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pbksd-0000BL-DR for pgsql-general@lists.postgresql.org; Mon, 13 Mar 2023 16:18:35 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pbksa-0000uk-W8 for pgsql-general@postgresql.org; Mon, 13 Mar 2023 16:18:35 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.15.2/8.15.2) with ESMTP id 32DGIRe91885981; Mon, 13 Mar 2023 12:18:27 -0400 From: Tom Lane To: Raivo Rebane cc: Christoph Moench-Tegeder , pgsql-general@postgresql.org Subject: Re: Binary large object processing problems In-reply-to: References: Comments: In-reply-to Raivo Rebane message dated "Mon, 13 Mar 2023 17:54:04 +0200" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <1885979.1678724307.1@sss.pgh.pa.us> Date: Mon, 13 Mar 2023 12:18:27 -0400 Message-ID: <1885980.1678724307@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Raivo Rebane writes: > Thank for answer, but I was also readed this manual and found there : > 35.3.2. Importing a Large Object You need to read the start of that section, which says All large object manipulation using these functions must take place within an SQL transaction block, As Christoph said, you're responsible for supplying a BEGIN and COMMIT around the call. regards, tom lane