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 1qsEJG-007DlI-8I for pgsql-hackers@arkaria.postgresql.org; Mon, 16 Oct 2023 03:30:26 +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 1qsEJD-00FEBR-5W for pgsql-hackers@arkaria.postgresql.org; Mon, 16 Oct 2023 03:30:23 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qsEJC-00FEBJ-TU for pgsql-hackers@lists.postgresql.org; Mon, 16 Oct 2023 03:30:23 +0000 Received: from sss.pgh.pa.us ([68.162.161.243]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qsEJ9-000taK-Ce for pgsql-hackers@lists.postgresql.org; Mon, 16 Oct 2023 03:30:22 +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 39G3UHKJ2191750; Sun, 15 Oct 2023 23:30:17 -0400 From: Tom Lane To: Thomas Munro cc: Noah Misch , Michael Paquier , Vik Fearing , cary huang , pgsql-hackers@lists.postgresql.org Subject: Re: Add support for AT LOCAL In-reply-to: References: <65b620bd-4f05-4381-97c3-5ec9ac39d5b9@postgresfriends.org> <2129576.1697407071@sss.pgh.pa.us> <2188264.1697425365@sss.pgh.pa.us> Comments: In-reply-to Thomas Munro message dated "Mon, 16 Oct 2023 16:07:20 +1300" MIME-Version: 1.0 Content-Type: text/plain; charset="UTF-8" Content-ID: <2191748.1697427017.1@sss.pgh.pa.us> Content-Transfer-Encoding: 8bit Date: Sun, 15 Oct 2023 23:30:17 -0400 Message-ID: <2191749.1697427017@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Thomas Munro writes: > On Mon, Oct 16, 2023 at 4:02 PM Tom Lane wrote: >> I'm having a hard time not believing that this is a compiler bug. >> Looking back at 8d2a01ae12cd and its speculation that xlc is overly >> liberal about reordering code around sequence points ... I wonder >> if it'd help to do this calculation in a local variable, and only >> assign the final value to result->time ? But we have to reproduce >> the problem first. > If that can be shown I would vote for switching to /opt/IBM/xlc/16.1.0 > and not changing a single bit of PostgreSQL. If switching to 16.1 removes the failure, I'd agree. It's hard to believe that any significant number of users still care about building PG with xlc 12. regards, tom lane