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 1sPEZk-003bO4-4r for pgsql-hackers@arkaria.postgresql.org; Thu, 04 Jul 2024 05:00:08 +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 1sPEZh-00DsWF-VM for pgsql-hackers@arkaria.postgresql.org; Thu, 04 Jul 2024 05:00:06 +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 1sPEZh-00DsW6-Jf for pgsql-hackers@lists.postgresql.org; Thu, 04 Jul 2024 05:00:06 +0000 Received: from mail-lf1-x12c.google.com ([2a00:1450:4864:20::12c]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sPEZg-000KU0-7j for pgsql-hackers@postgresql.org; Thu, 04 Jul 2024 05:00:05 +0000 Received: by mail-lf1-x12c.google.com with SMTP id 2adb3069b0e04-52ea0f18500so88335e87.3 for ; Wed, 03 Jul 2024 22:00:03 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1720069202; x=1720674002; darn=postgresql.org; h=content-transfer-encoding:in-reply-to:from:references:cc:to :content-language:subject:user-agent:mime-version:date:message-id :from:to:cc:subject:date:message-id:reply-to; bh=KpkQhMDRbwqKf3ihXgMeTGHYGKZDPgi59fs/odxigB8=; b=m8wm9FSCANeFBHflddRP5lVPuOMkNDRlvhRqytRObkeMdXewQIkg7zvRIql72chXGD WYjp4mP0e7tie3u3/D8Z2OgFHXp/ZGz3ATiHs06WMaJDuOFiYNoWBzqew3+3wiSpRmJ3 M8T6AhYrsLMvI74/q1CZSSc7o13LBkEG6Zq5oYXyuRILuRaWRfhc2WO3tYQdPBAMebRj HBz4nd9z3dHX/UalxmwYscn5bKE0h2GWo7BNDmP7JFh0MQBWMX50x5TvEXlnHlo/fGkg 9nTCYgo1dSnUgMCJgxjOOknMhh9X+mKQ36FKg+0jb+vKq3h8kaYrd8SOdK73+ZzDuTJk rJRw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1720069202; x=1720674002; h=content-transfer-encoding:in-reply-to:from:references:cc:to :content-language:subject:user-agent:mime-version:date:message-id :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=KpkQhMDRbwqKf3ihXgMeTGHYGKZDPgi59fs/odxigB8=; b=GqV2JmXMqkaYvNeURJD7BO9CRtha9d85bUEGfjraf2wRqcWe9TiD7Dj4SbeA0rYqmM cI9t+1bBGDvsogodV4BKqFofOadQeMIi/RNHyVA4Lc8Sgded5bCkP2WgymbVXUTcSWuC gmGX2hNeVPK0ke2p1Q0rJHD65mz25SOhhYhLrRxBrfUpMqZ13Sq5wwERBXqsf0COhB5i +Gznuz1BsybrKZsuEcjxxNZixKBUYs8zK9l17qi4qrtBz/jSpBA2LFcwJs9itE8Jhhux /4NEK+WrCGoyQtUtcq6BkjGTAr2wkll9L/jNwSy+5rbml0ASplCro0kWuW/7zGbLwfIx j0Tg== X-Gm-Message-State: AOJu0YwWKXWKWS3Mh0aAfub/eaaTEW52Ys6bFlIjbvRfh2TUbuiFB7vr AbVOQsHpLMTBFpIMc7gNCB8lGRatJLn/y4Re5xY0n8FSRE3sKS7H X-Google-Smtp-Source: AGHT+IEkWIGY90hGxD4buZ07KzQNIylg8Lw+fMCJ+doVV9wZo096hZOrZRpQsGviYehwFzgxDJVzIA== X-Received: by 2002:ac2:5332:0:b0:52e:9f6b:64 with SMTP id 2adb3069b0e04-52ea063ebdamr251882e87.34.1720069202399; Wed, 03 Jul 2024 22:00:02 -0700 (PDT) Received: from [1.0.0.7] ([178.155.22.46]) by smtp.gmail.com with ESMTPSA id 2adb3069b0e04-52e7ab0bbf0sm2309025e87.25.2024.07.03.22.00.01 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Wed, 03 Jul 2024 22:00:01 -0700 (PDT) Message-ID: Date: Thu, 4 Jul 2024 08:00:00 +0300 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.4.2 Subject: Re: race condition in pg_class Content-Language: en-US To: Noah Misch , Robert Haas Cc: pgsql-hackers@postgresql.org, Tom Lane , Smolkin Grigory , Michael Paquier References: <20231027214946.79.nmisch@google.com> <1617596.1698446455@sss.pgh.pa.us> <20231027232612.99.nmisch@google.com> <20231102030915.d3.nmisch@google.com> <20240512232923.aa.nmisch@google.com> <20240605181706.fe.nmisch@google.com> <20240611024525.9f.nmisch@google.com> <20240614003549.c2.nmisch@google.com> <20240621212842.98.nmisch@google.com> <20240628051353.a0.nmisch@google.com> From: Alexander Lakhin In-Reply-To: <20240628051353.a0.nmisch@google.com> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hello Noah, 28.06.2024 08:13, Noah Misch wrote: > Pushed. ... Please look also at another anomaly, I've discovered. An Assert added with d5f788b41 may be falsified with: CREATE TABLE t(a int PRIMARY KEY); INSERT INTO t VALUES (1); CREATE VIEW v AS SELECT * FROM t; MERGE INTO v USING (VALUES (1)) AS va(a) ON v.a = va.a   WHEN MATCHED THEN DO NOTHING   WHEN NOT MATCHED THEN DO NOTHING; TRAP: failed Assert("resultRelInfo->ri_TrigDesc"), File: "nodeModifyTable.c", Line: 2891, PID: 1590670 Best regards, Alexander