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 1r7vWY-007Wjs-1R for pgsql-bugs@arkaria.postgresql.org; Tue, 28 Nov 2023 10:41:02 +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 1r7vWV-004R96-EP for pgsql-bugs@arkaria.postgresql.org; Tue, 28 Nov 2023 10:40:59 +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 1r7vUq-004Ozh-3l for pgsql-bugs@lists.postgresql.org; Tue, 28 Nov 2023 10:39:16 +0000 Received: from lahtoruutu.iki.fi ([185.185.170.37]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1r7vUn-008x9G-Hk for pgsql-bugs@lists.postgresql.org; Tue, 28 Nov 2023 10:39:15 +0000 Received: from [192.168.1.115] (dsl-hkibng22-54f8db-125.dhcp.inet.fi [84.248.219.125]) (using TLSv1.3 with cipher TLS_AES_128_GCM_SHA256 (128/128 bits) key-exchange X25519 server-signature RSA-PSS (2048 bits) server-digest SHA256) (No client certificate requested) (Authenticated sender: hlinnaka) by lahtoruutu.iki.fi (Postfix) with ESMTPSA id 4Sff8J3BrLz49PwY; Tue, 28 Nov 2023 12:39:09 +0200 (EET) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=iki.fi; s=lahtoruutu; t=1701167952; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:mime-version:mime-version:content-type:content-type: content-transfer-encoding:content-transfer-encoding: in-reply-to:in-reply-to:references:references; bh=ds8xS5xGIkLKJQuo9yPQhMedjIh4BY2yOfMvOncYBF0=; b=OFK75h4jOFAF5+mWedX/9pN2wvEznYUZP+6FLTMsdbFkjhbGYnabEVXe6+61fs9aHWoXQF K3a9vU5Vw5axymKotsxbe8PbiSCgpxU5ILg70qoQbwFva2bhK5wcxtpUuqo9/c6m0UAgEu EH91ViLg72H0AoaqT8PkyNPXqFZLjeVx5qtLYJ5FUSDTxjQ7656NflYLXarEoLA8CPG77y FLJpTlAYwywa38xmGr9P7olPQNFy+e7XnlrjUdd9KFMsdCRrAMYe9bRA8lFeWkrwYWUIOO oL6C56B0SO7UNeMsrG2rfNMcvzeLW8QjjCZl0pc/F/gkk2NtN4ajutUnuGsR0A== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=iki.fi; s=lahtoruutu; t=1701167952; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:mime-version:mime-version:content-type:content-type: content-transfer-encoding:content-transfer-encoding: in-reply-to:in-reply-to:references:references; bh=ds8xS5xGIkLKJQuo9yPQhMedjIh4BY2yOfMvOncYBF0=; b=aySJRcvuHU93Z9uzuszB5bGFLic6QXp0vE3j+Df07q7gXlwpJtx2qtbZrS+RsvWgiN3cnx /SR+Ar0iFtNpfw7FM4FajEMlXTUQsvwunPZf/C3sHym4KiBHvrzPfvWSvd9b4d1NG7qJtz UMww7gKPHkn9lqo/VjVWftyXgDwWB1FQz5Eh+Sc+0guwHWSRo22Nau1frujmPJvzMjTvj6 V7DusNBAM8z1LPoGNzjjP2QER2Y2LZbV8xNi/qM/Rc6ROWoEwLNNkGgegFINyCIBHN/5f/ TkEBlirJ6dAYhbtK9Ag4pvX1kIo8cPwvzydQstXlwy8yOr1ffhGHMN5TJzBTIg== ARC-Seal: i=1; s=lahtoruutu; d=iki.fi; t=1701167952; a=rsa-sha256; cv=none; b=pmUyOrKUjRsblC16IEDp7tGclgR7opl5Aw9sgLqY2Rz5aMghR/UUEBWAU+0UssLPC5NeKz TmqJBLUb+8w0Ya26Uzu4cCtcAGZaCCNYLRUS1+GRur3sbBL2HjO0SCVJD6bw8kxFwUA1dZ URVoQY7rTivKIzodpNbNLX/dJuP2viuceBzmXOhkFmRzXVG4woJd7SHHb8tu+1lPszPXAl fEs1eyAnYzwBUqImp/YZQ/z/oEIXEeWxYvHkNH2rbma3unQW4cKA0fk7FLMwxNbTZ+nGln ASU/7iTGGZdhusu9S4ca16vYmZQEH6O3kpOTUJwdmgJ3asbgI9Mg8XIgl5u5WQ== ARC-Authentication-Results: i=1; ORIGINATING; auth=pass smtp.auth=hlinnaka smtp.mailfrom=hlinnaka@iki.fi Message-ID: Date: Tue, 28 Nov 2023 12:39:09 +0200 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: BUG #17893: Assert failed in heap_update()/_delete() when FK modiified by RI trigger in non-read-committed xact Content-Language: en-US To: Alexander Lakhin , pgsql-bugs@lists.postgresql.org, Andres Freund References: <17893-35847009eec517b5@postgresql.org> <1236e144-d772-7ff4-6e23-4ce91d0923ad@gmail.com> <0c6e10cd-9288-4dda-b35e-7a64684367d3@iki.fi> <8b695b41-a006-f4d2-545f-c99db7595ee2@gmail.com> From: Heikki Linnakangas In-Reply-To: <8b695b41-a006-f4d2-545f-c99db7595ee2@gmail.com> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 28/11/2023 11:00, Alexander Lakhin wrote: > 27.11.2023 22:23, Heikki Linnakangas wrote: >> I propose to attached slight variation, which moves the assertions before the crosscheck snapshot check. The >> assertions are correct as they are, if you don't need to take the crosscheck into account. > > Thank you for paying attention to this! > I agree with your variation, it's more accurate. Committed and backpatched. Thank you! -- Heikki Linnakangas Neon (https://neon.tech)