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 1k2iZl-0001YQ-4R for pgsql-docs@arkaria.postgresql.org; Mon, 03 Aug 2020 22:04:57 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1k2iZk-0006Fs-1N for pgsql-docs@arkaria.postgresql.org; Mon, 03 Aug 2020 22:04:56 +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 1k2iZj-0006Fi-SG for pgsql-docs@lists.postgresql.org; Mon, 03 Aug 2020 22:04:55 +0000 Received: from momjian.us ([72.94.173.45]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1k2iZh-0007sE-Dv for pgsql-docs@postgresql.org; Mon, 03 Aug 2020 22:04:55 +0000 Received: from bruce by momjian.us with local (Exim 4.92) (envelope-from ) id 1k2iZb-0008D8-BI; Mon, 03 Aug 2020 18:04:47 -0400 Date: Mon, 3 Aug 2020 18:04:47 -0400 From: Bruce Momjian To: Alvaro Herrera Cc: "Andrey M. Borodin" , Anna Akenteva , pgsql-docs@postgresql.org Subject: Re: [DOCS] Let's document a bytea bug Message-ID: <20200803220447.GG17519@momjian.us> References: <20200803202042.GC17519@momjian.us> <20200803213947.GA1118@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20200803213947.GA1118@alvherre.pgsql> User-Agent: Mutt/1.10.1 (2018-07-13) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On Mon, Aug 3, 2020 at 05:39:47PM -0400, Alvaro Herrera wrote: > On 2020-Aug-03, Bruce Momjian wrote: > > > So, the character and octet length is 600 million, but on output, that > > will be expanded, and both SELECT and pg_dump fail. I also can't see > > how to improve the error message since it happens so low in the stack. > > I think you'll find commits fa2fa9955280 and b66adb7b0c83 amusing. Yeah, I saw those, but they were dealing with tuple length limits, but I also saw they were reverted, so this is a hard problem. -- Bruce Momjian https://momjian.us EnterpriseDB https://enterprisedb.com The usefulness of a cup is in its emptiness, Bruce Lee