Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps
 (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <pgsql-bugs-owner+archive@lists.postgresql.org>)
	id 1qJsEl-00083d-BS
	for pgsql-bugs@arkaria.postgresql.org; Thu, 13 Jul 2023 09:03:47 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.92)
	(envelope-from <pgsql-bugs-owner+archive@lists.postgresql.org>)
	id 1qJsEi-0004Y6-ET
	for pgsql-bugs@arkaria.postgresql.org; Thu, 13 Jul 2023 09:03:44 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <a.kutepow@prodat-sql.de>)
	id 1qJsEi-0004Xx-5x
	for pgsql-bugs@lists.postgresql.org; Thu, 13 Jul 2023 09:03:44 +0000
Received: from mail.prodat-sql.de ([116.202.227.166])
	by makus.postgresql.org with esmtps  (TLS1.2) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <a.kutepow@prodat-sql.de>)
	id 1qJsEd-0009zy-SA
	for pgsql-bugs@lists.postgresql.org; Thu, 13 Jul 2023 09:03:42 +0000
Received: from [192.168.178.136] ([24.134.240.97])
        by mail.prodat-sql.de (IceWarp 12.0.2.1 x64) with ASMTP (SSL) id
 202307131103372968;
        Thu, 13 Jul 2023 11:03:37 +0200
Message-ID: <75a978b2-f723-f605-8635-73b9ac52e28c@prodat-sql.de>
Date: Thu, 13 Jul 2023 11:03:37 +0200
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:102.0) Gecko/20100101
 Thunderbird/102.13.0
Subject: Re: BUG #18019: misbehaviour by replication
To: "Hayato Kuroda (Fujitsu)" <kuroda.hayato@fujitsu.com>
Cc: "pgsql-bugs@lists.postgresql.org" <pgsql-bugs@lists.postgresql.org>
References: <18019-21e3fdb5d9057921@postgresql.org>
 <TYAPR01MB58660F0D9599DA216F9331D4F537A@TYAPR01MB5866.jpnprd01.prod.outlook.com>
From: =?UTF-8?Q?Andr=c3=a9_Kutepow?= <a.kutepow@prodat-sql.de>
In-Reply-To: 
 <TYAPR01MB58660F0D9599DA216F9331D4F537A@TYAPR01MB5866.jpnprd01.prod.outlook.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
List-Id: <pgsql-bugs.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-bugs@lists.postgresql.org>
List-Owner: <mailto:pgsql-bugs-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-bugs>
Archived-At: 
 <https://www.postgresql.org/message-id/75a978b2-f723-f605-8635-73b9ac52e28c%40prodat-sql.de>
Precedence: bulk

> When you updated that filter column from TRUE to FALSE, we think you hoped that it would not replicate.
no, I hoped thar it would replicate, but I was hoping to get an error in 
the log that this was not possible, since this record is referenced from 
another table and cannot be simply deleted, what we see by a regular 
DELETE attempt

Best Regards,
Andre