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 ) id 1p8GUt-00010r-I0 for pgsql-hackers@arkaria.postgresql.org; Thu, 22 Dec 2022 08:00:11 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1p8GUs-0002N3-Gf for pgsql-hackers@arkaria.postgresql.org; Thu, 22 Dec 2022 08:00:10 +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 ) id 1p8GUs-0002L6-4R for pgsql-hackers@lists.postgresql.org; Thu, 22 Dec 2022 08:00:10 +0000 Received: from mail-oa1-x35.google.com ([2001:4860:4864:20::35]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1p8GUp-0001kD-PW for pgsql-hackers@lists.postgresql.org; Thu, 22 Dec 2022 08:00:09 +0000 Received: by mail-oa1-x35.google.com with SMTP id 586e51a60fabf-1443a16b71cso1638062fac.13 for ; Thu, 22 Dec 2022 00:00:07 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=LO8p9eCVIE2aDeAZb0IC6l7wBZsLPx3NeDmZIjPUgQY=; b=FEtBHiH9bcgZ8q4x7eE+fPMbUSFUXxpmbSO9kUsN4jcJyQRwHNmYrUzWY43SUPumcj /mpNd8lyKu42XQQzZRQsg4Zl5266hF+r4tOlwaHqLU9RN4AAqmy+uEFeBeMPNpF8LWrL /F4v+U89g4WgV49AbdlCG+nFzJKy7V5igYnFnhJhtQWZPQ7zTGuxOGCvuIGtT1y7ys4C OY7QP4K2kf9shr/ZM0K5VOVZdUo7GQempgPmAIjfdIK+wz0G+M72o7Fs/vBbZkdNb+uR bh8+mNy/7kVTRqsG3VcxHNZX/3nrD+FPDnMbvntineapRcCYwp8VwWiHI/yeJshH6Pzm L7fg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=LO8p9eCVIE2aDeAZb0IC6l7wBZsLPx3NeDmZIjPUgQY=; b=0o83Dwdhei7TNOMpJ+F4JXZOkxf1pmTEBNnV2AGxiGMWv8DrLPy+YPw1F1Mf209J3D DdZmB156COXZuUFDm3CJaLSVMNyN7xPo5Q25Bp+Cozo4P9C0AkMAkeyP5p7bJzUxyOMi EP9HohRsgMKp0LAn+t8pK0+ALL+uvgX3/2g6rJz0mgvo4TywqFi74fdwO5jQwWG60lvG 0jAh8T2WpRGamvnt/ic7kt4rLHjjcSgF+a26s/zl2GQVCde3UZMSWqJ9SAFpiqZmoP7q VJTmWzGkqU78gJaCnwZ8OIW6WZeeeSBNDOtexo3sRbSjR+PZqQtxPN8eGbaqW3G2UITc 5OFg== X-Gm-Message-State: AFqh2kpEP9XRTQ9VEPEciivePwKK75i9O/6qLluUr7zvJI+CStHYcyDK s2j/HPYaya7ZfRYoyb9BlrERttnD6NzfZdq5qWs= X-Google-Smtp-Source: AMrXdXtoF1iQtXptqCPybDAIS83apsViMd/vk7LV5+r5oN72hGaAOUsF28qQmNwdFD5SQOHMoxfjwCgmymCgJ+T3DYk= X-Received: by 2002:a05:6871:293:b0:144:f2f6:c212 with SMTP id i19-20020a056871029300b00144f2f6c212mr376537oae.278.1671696007216; Thu, 22 Dec 2022 00:00:07 -0800 (PST) MIME-Version: 1.0 References: In-Reply-To: From: Masahiko Sawada Date: Thu, 22 Dec 2022 16:59:30 +0900 Message-ID: Subject: Re: Force streaming every change in logical decoding To: "Hayato Kuroda (Fujitsu)" Cc: Amit Kapila , "shiy.fnst@fujitsu.com" , Peter Smith , Dilip Kumar , PostgreSQL Hackers Content-Type: text/plain; charset="UTF-8" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Thu, Dec 22, 2022 at 4:18 PM Hayato Kuroda (Fujitsu) wrote: > > Dear Amit, > > Thank you for updating the patch. I have also checked the patch > and basically it has worked well. Almost all things I found were modified > by v4. > > One comment: while setting logical_decoding_mode to wrong value, > I got unfriendly ERROR message. > > ``` > postgres=# SET logical_decoding_mode = 1; > ERROR: invalid value for parameter "logical_decoding_mode": "1" > HINT: Available values: , immediate > ``` > > Here all acceptable enum should be output as HINT, but we could not see the empty string. > Should we modify config_enum_get_options() for treating empty string, maybe > like (empty)? Good point. I think the hint message can say "The only allowed value is \"immediate\" as recovery_target does. Or considering the name of logical_decoding_mode, we might want to have a non-empty string, say 'normal' as Kuroda-san proposed, as the default value. Regards, -- Masahiko Sawada Amazon Web Services: https://aws.amazon.com