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.98.2) (envelope-from ) id 1xTELq-00000000CSd-2LHb for pgsql-hackers@arkaria.postgresql.org; Tue, 17 Nov 2026 08:15:39 +0000 Received: from localhost ([127.0.0.1]:46148 helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.98.2) (envelope-from ) id 1xTEKq-00000003ZuO-3hSD for pgsql-hackers@arkaria.postgresql.org; Tue, 17 Nov 2026 08:14:36 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]:40748) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1xTEKq-00000003ZuG-2TC6 for pgsql-hackers@lists.postgresql.org; Tue, 17 Nov 2026 08:14:36 +0000 Received: from mail-wm1-x334.google.com ([2a00:1450:4864:20::334]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1xTEKo-0000000077s-1kJf for pgsql-hackers@postgresql.org; Tue, 17 Nov 2026 08:14:35 +0000 Received: by mail-wm1-x334.google.com with SMTP id 5b1f17b1804b1-4bb6886d30aso18842905e9.3 for ; Tue, 17 Nov 2026 00:14:34 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20260707; t=1794903273; x=1795508073; darn=postgresql.org; h=in-reply-to:content-disposition:content-type:mime-version :references:message-id:subject:cc:to:from:date:from:to:cc:subject :date:message-id:reply-to:content-type; bh=PUu3kPrjuPW7wTROxOTWT4HJSutMwrRV6W05BmktUQk=; b=kXLieac6m755EAUwdsDf+CqFxf4sB07cCBc8QbPgjokMy6C0rWkTaMgDNLoUYRmQyY zzQW8JqPClyxg3P2ZjgPDuwJBkYKPRY8uYqcEoCvo32ODWl3eK0qzDYZNgsuVpCPNrPi AqbE2YU2DbHUCMcI8Wg9UXLW1QqbAMstMtWglquzY8YwoErdZPD78CaeCpdDMjiR1hIm GEkdW0THUxm3fic8xA7ab4s+6QMkWx+QLEsbWjUD493SdiZkbZXZULjvNQ+tFgxhYppQ /1BCBQ2F/A//R5JvVizAe9wzxoGCL09KEL7RATM4S6qwAKfr3uAGEe4Ffx7XkzPYZn2g tWpA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20260707; t=1794903273; x=1795508073; h=in-reply-to:content-disposition:content-type:mime-version :references:message-id:subject:cc:to:from:date:x-gm-gg :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to :content-type; bh=PUu3kPrjuPW7wTROxOTWT4HJSutMwrRV6W05BmktUQk=; b=eEvosjVLcczbgGd8W9LjeOmm/esqBF+C4RgJ6eudfFiM7obT1ayu8dgOqw4OzjvaVO pm9kgxeSlwSzgxeuzsZvMywWLMuUq0Eia3NBNESKDdfuvqN0AeVug/bUop1FqGWxkwSv a6P/iwhtmQvFdREPxj7Vmc/Yr8hNwv64o5OrxKWPsNKyRclsWOWVixIM2f8ZIDI2e/jI e08/SqfAiIVQ5r5sTk0Qzk2k2H3QMCk5SQ6H/0oMRcviNMm+f3e8EKiBzWfFnN0HCOLw An0YM/0XBwzYmzBMBseLv1bAv8Y8tH+Mrz30o8vg0TqeiLLyoRIc74v7fqHinN4YtLju 0Fiw== X-Forwarded-Encrypted: i=1; AL+hErEA2v5vte8wzLxAYpJy5h6CawIhxwktMFZlHh0nBVIbETQ2A5ljWfjjtHfGQng/3eyip65K1AkNrsjv/hmF@postgresql.org X-Gm-Message-State: APuU4Z9gvUOcAuxf8EeMD222tW++cZ12VqCZzM0VSW/XDsxXZs6Wvdie 2dsTA/DVgud8DVmpYxQZMwCOPlFsR5dpvAxgqTc6c+VvOEYfzknJQuO4 X-Gm-Gg: AYBFou0DKf4HwvuAArqxZRUrznKBVe5eYb3GnZrDM8T9Jku6Jt3lDEljDoj/FB/RJXi fhs+CQpiet6us+Ciw5L//XUeA3yupxyea3UnHMMNtQ0q95U0QUsLwzM9FdSlx3oTah1PtXWaPN5 pFgSjYMU6+rJczdRKcuzRaFf1m4CHDEF2pp7jRNKMURa2A98ZrqJKRZyAWWK+cSW8C2Kwxp4WIY At3JsdUWU8HDBtmhw2FDxMWUUE7ubDm82lpUw4PTWRF+ccL0GaCxMlfMLV1xb7iEuLaW8BJT1y/ +YlO/NViHcw3fyVu/qoNhtD6q3v+QQskzrqN8voG6hwrjXg9MkEcdD+Ge44HMIYNFfUF9V9bG2H Z74NUeLS8ChJ7rbjq6apZAgAyo8fZhsYj0FsVR2gFGL4J5ml2wc32CTH/6z4s7+/y+MH3BFAdED OUSE63e+MRDGmqJdPWk5ZctuKMTXvp4T5fRKkVQLC+8qNTfMI+gsBj7VN3APOeAKI2YcyK38wUd A5cS/Ft+zuD/lUQsZVbqQYLLcmfIjnR9ZZiEO2vHiwFe0nm/eK/Y1SrRNoLhfwmUrlMzI7bqFXS x6Gu59PhbgWkJMA2QGnjFtQgK/fbkoiZ65VuTbMqj6zsyQabR6+gRLyk/UIqpPIWhlV43Z6rr80 7Q8D1tOQS1xyLvw== X-Received: by 2002:a05:600c:4746:b0:4a1:813f:2a60 with SMTP id 5b1f17b1804b1-4bb55a6a642mr290374535e9.11.1794903272499; Tue, 17 Nov 2026 00:14:32 -0800 (PST) Received: from bdtpg (ec2-15-237-197-144.eu-west-3.compute.amazonaws.com. [15.237.197.144]) by smtp.gmail.com with ESMTPSA id 5b1f17b1804b1-4bb62d0d430sm107786055e9.3.2026.11.17.00.14.31 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Tue, 17 Nov 2026 00:14:31 -0800 (PST) Date: Tue, 17 Nov 2026 08:14:30 +0000 From: Bertrand Drouvot To: Masahiko Sawada Cc: Zhijie Hou , Amit Kapila , Bharath Rupireddy , Chao Li , Fujii Masao , PostgreSQL-development Subject: Re: Add a hook for handling logical decoding messages on subscribers. Message-ID: References: <4d9e1d2f-27a2-40ec-92c8-4b5740736cf8@gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi, On Mon, Nov 16, 2026 at 11:05:00AM -0800, Masahiko Sawada wrote: > > I've attached the updated patches. Thanks! I did not look in details but I have a question. I'm wondering what would happen with an unpatched publisher when both messages and streaming are enabled. Suppose a message is emitted in a subtransaction that is later aborted. The publisher sends the top level XID with the message, whereas STREAM ABORT refers to the subtransaction XID. IIUC, the patched subscriber would therefore not discard that message. Should 0002 handle this case somehow? Regards, -- Bertrand Drouvot PostgreSQL Contributors Team RDS Open Source Databases Amazon Web Services: https://aws.amazon.com