Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gxEBE-0000ci-H7 for pgsql-bugs@arkaria.postgresql.org; Fri, 22 Feb 2019 17:00:08 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gxEBC-0007sX-UN for pgsql-bugs@arkaria.postgresql.org; Fri, 22 Feb 2019 17:00:06 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gxDpk-0003t5-4j for pgsql-bugs@lists.postgresql.org; Fri, 22 Feb 2019 16:37:56 +0000 Received: from mail-wr1-x429.google.com ([2a00:1450:4864:20::429]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gxDph-00070E-Pf for pgsql-bugs@lists.postgresql.org; Fri, 22 Feb 2019 16:37:55 +0000 Received: by mail-wr1-x429.google.com with SMTP id r5so3031197wrg.9 for ; Fri, 22 Feb 2019 08:37:53 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=vaion.com; s=google; h=subject:to:cc:references:from:message-id:date:user-agent :mime-version:in-reply-to:content-language; bh=l/4mmWbaWGtgOBHSH7qsMD4aemSFLf6h8GHOgfdzw70=; b=VZNCpXFdeFa4YSMzzjIQhpNSFMPc9bx5716V64EJ4E5zDgPL8fFNY5GpbFvbLvasrH GTpTqpfFkaCy48kCMhvBYk2pAZLy3xyW9DApJYSZZngKh+SSzDxxiM2WD9p6QrDc2Up6 3NrNOaNXPdp3h1FL9eWQQC65my1GeTmpbJHOTbAlqVsYx8h9wHDf8W4EHc4HZgiAMZPA gILLQ3UQ1zAwrd8DH8ILeJm7zs8oAtE7Se3qTZHUSKInR5Stw6gjfmRiFxMdRTdywQZU 0JaTihToCm+OwFvfDct5Ot9d+OICSkxETKVA9g5Fvn3k7X6fGZEdDAAgzxf0LAgVJbsH oqGw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:subject:to:cc:references:from:message-id:date :user-agent:mime-version:in-reply-to:content-language; bh=l/4mmWbaWGtgOBHSH7qsMD4aemSFLf6h8GHOgfdzw70=; b=rM2FhuA3K4JlaFbEqEYszvH5hY4y7H8Q7Z/+15lUzH1YVNN6k6UaEn5BC4R4l8zdvV uk8QYVQlYRj0zCmhGYBb3e8sWldLlglnaowdvxqKTBItC10Y3kAlXgs1Vg7aCHGZcGVR Qlh7ZRfMS19d8vH2fBg4s5jYBqAxhKg9PhcLQ4sZzRzeW89p1i93MB99JDFtkDvTaZy4 IzRBjR1gxL0+RNeCnB6iH4tFIuhH6E7qVoVRNkBvwKd4/bD9nC5K04fPB0AP+jDWoOJD MDCJk1DdKJioXWXe9FHKzpE8N+TwsQRg9P4icZ2kjyxC5q+FxKS8QdD9nKaqaC2wL4na lZ1Q== X-Gm-Message-State: AHQUAuZHy2rfa5rHAHJwT9ZeR90e1VqR2QlAbwh5SLtAfkI+jSteOZKz +R8hm4UZkKgWqYSzBLfBgVmMNoDDlDCEhGqD X-Google-Smtp-Source: AHgI3IY7Nn7ZA4LstXdAJQp48aig/zUWEYj3WRZA7UFtTkEGRqFjNz89QHRfOpFbpgCW7DCBWFmhvQ== X-Received: by 2002:adf:e8cf:: with SMTP id k15mr3457100wrn.193.1550853472571; Fri, 22 Feb 2019 08:37:52 -0800 (PST) Received: from [10.10.2.144] (51-148-98-141.dsl.zen.co.uk. [51.148.98.141]) by smtp.gmail.com with ESMTPSA id 62sm1183669wra.46.2019.02.22.08.37.51 (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Fri, 22 Feb 2019 08:37:51 -0800 (PST) Subject: Re: BUG #15293: Stored Procedure Triggered by Logical Replication is Unable to use Notification Events To: Andres Freund , Tom Lane Cc: Sergei Kornilov , pgsql-hackers@postgresql.org, Peter Eisentraut , Marc Dean , Petr Jelinek , "michael.paul.powers@gmail.com" , "pgsql-bugs@lists.postgresql.org" References: <153243441449.1404.2274116228506175596@wrigleys.postgresql.org> <45136061532438385@iva3-a2a8aac410a1.qloud-c.yandex.net> <20180724155829.zq22vov6d7erhxsx@alap3.anarazel.de> <648481532456538@myt5-0fa3e541b8b9.qloud-c.yandex.net> <20180724192740.6yn2xregaz6yhpc2@alap3.anarazel.de> <13844.1532468610@sss.pgh.pa.us> <20180724215604.hwl4xk2v4ulkgvwk@alap3.anarazel.de> <14887.1532469693@sss.pgh.pa.us> <20180724220630.zu5w3m25xzqa6jqp@alap3.anarazel.de> From: Robert Welin Message-ID: <1788fd6f-308a-77e7-ef82-a2325f506ed6@vaion.com> Date: Fri, 22 Feb 2019 16:37:50 +0000 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:60.0) Gecko/20100101 Thunderbird/60.4.0 MIME-Version: 1.0 In-Reply-To: <20180724220630.zu5w3m25xzqa6jqp@alap3.anarazel.de> Content-Type: multipart/alternative; boundary="------------27B9DCB10117AC761D137129" Content-Language: en-US List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk This is a multi-part message in MIME format. --------------27B9DCB10117AC761D137129 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit I have reproduced this bug on PostgreSQL version 10.7 and 11.2 using the steps described in Michael Powers' original report. The issue also still seems to be present even with the patch provided by Sergei Kornilov. Are there plans to address this issue any time soon or is there some way I can assist in fixing it? It would be great to have notifications from logical replication. Regards, Robert Welin --------------27B9DCB10117AC761D137129 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 7bit 
I have reproduced this bug on PostgreSQL version 10.7 and 11.2 using the
steps described in Michael Powers' original report. The issue also still
seems to be present even with the patch provided by Sergei Kornilov.

Are there plans to address this issue any time soon or is there some way
I can assist in fixing it? It would be great to have notifications from
logical replication.

Regards,
Robert Welin
--------------27B9DCB10117AC761D137129--