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.94.2) (envelope-from ) id 1qt91C-00B1JY-VF for pgsql-hackers@arkaria.postgresql.org; Wed, 18 Oct 2023 16:03:34 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qt90C-005uF3-UR for pgsql-hackers@arkaria.postgresql.org; Wed, 18 Oct 2023 16:02:33 +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.94.2) (envelope-from ) id 1qt90C-005uEp-KT for pgsql-hackers@lists.postgresql.org; Wed, 18 Oct 2023 16:02:33 +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.94.2) (envelope-from ) id 1qt90A-001730-TP for pgsql-hackers@lists.postgresql.org; Wed, 18 Oct 2023 16:02:32 +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 39IG2S7I3122653; Wed, 18 Oct 2023 12:02:28 -0400 From: Tom Lane To: Robert Haas cc: Thomas Munro , Michael Paquier , Noah Misch , Vik Fearing , cary huang , pgsql-hackers@lists.postgresql.org Subject: Re: Add support for AT LOCAL In-reply-to: References: <2188264.1697425365@sss.pgh.pa.us> <2191749.1697427017@sss.pgh.pa.us> <20231016045804.c0@rfd.leadboat.com> <20231016055051.3a@rfd.leadboat.com> <2208907.1697435663@sss.pgh.pa.us> <20231016060510.72@rfd.leadboat.com> <2659915.1697521218@sss.pgh.pa.us> <2726901.1697556666@sss.pgh.pa.us> <2820407.1697561128@sss.pgh.pa.us> <2995973.1697583273@sss.pgh.pa.us> <3001171.1697585525@sss.pgh.pa.us> Comments: In-reply-to Robert Haas message dated "Wed, 18 Oct 2023 11:38:18 -0400" MIME-Version: 1.0 Content-Type: text/plain; charset="UTF-8" Content-ID: <3122651.1697644948.1@sss.pgh.pa.us> Content-Transfer-Encoding: 8bit Date: Wed, 18 Oct 2023 12:02:28 -0400 Message-ID: <3122652.1697644948@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Robert Haas writes: > On Tue, Oct 17, 2023 at 7:35 PM Tom Lane wrote: >> Discounting the Windows animals, it looks like the xlc animals are >> our only remaining ones that use anything except gcc or clang. > After some research I determined that the release date for xlc 12.1 > seems to be June 1, 2012. At that time, clang 3.1 was current and just > after, GCC release version 4.7.1 was released. The oldest version of > clang that I find in the buildfarm is 3.9, and the oldest version of > gcc I find in the buildfarm is 4.6.3. So, somewhat to my surprise, xlc > is not the oldest compiler that we're still supporting in the > buildfarm. But it is very old, and it seems like that gcc and clang > are going to continue to gain ground against gcc and other proprietary > compilers for some time to come. Probably. Independent of that, it's fair to ask why we're still testing against xlc 12.1 and not the considerably-more-recent xlclang, or at least xlc 16.1. (I also wonder why we're still testing AIX 7.1 rather than an OS version that's not EOL.) > What does concern me is finding and coding > around compiler bugs. 19fa977311b9da9c6c84f0108600e78213751a38 is just > ridiculous, IMHO. I would agree, except for the downthread discovery that the bug is still present in current xlc and xlclang. Short of blowing off AIX altogether, it seems like we need to do something about it. regards, tom lane