Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1w1szi-000gkK-05 for pgsql-bugs@arkaria.postgresql.org; Sun, 15 Mar 2026 21:27:30 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w1szf-005mnI-2p for pgsql-bugs@arkaria.postgresql.org; Sun, 15 Mar 2026 21:27:28 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1w1szf-005mnA-1u for pgsql-bugs@lists.postgresql.org; Sun, 15 Mar 2026 21:27:28 +0000 Received: from sss.pgh.pa.us ([68.162.161.243]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1w1szZ-00000000IRm-2ylC for pgsql-bugs@lists.postgresql.org; Sun, 15 Mar 2026 21:27:27 +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 62FLRKBS2128102; Sun, 15 Mar 2026 17:27:20 -0400 From: Tom Lane To: 303677365@qq.com cc: pgsql-bugs@lists.postgresql.org Subject: Re: BUG #19433: json_object_agg_unique Crashes When Used as Window Function In-reply-to: <19433-74818a14ca269428@postgresql.org> References: <19433-74818a14ca269428@postgresql.org> Comments: In-reply-to PG Bug reporting form message dated "Fri, 13 Mar 2026 03:14:26 -0000" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <2128100.1773610040.1@sss.pgh.pa.us> Date: Sun, 15 Mar 2026 17:27:20 -0400 Message-ID: <2128101.1773610040@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk PG Bug reporting form writes: > The following bug has been logged on the website: > Bug reference: 19433 > Logged by: chunling qin > Email address: 303677365@qq.com > PostgreSQL version: 15.0 > Operating system: centos It is not helpful to send us inaccurate bug reports against old versions of Postgres, especially old development versions. In this case, your report of "15.0" is incorrect, and so is this: > | PostgreSQL Version | 15devel (development build) | > | Commit | 7103ebb7aa | How do I know? Because json_object_agg_unique() didn't exist before v16. You're wasting our time and yours by sending such inaccurate and outdated reports. Please make sure that bug reports can be reproduced against latest Postgres release versions or very recent master branch. regards, tom lane