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.96) (envelope-from ) id 1wHg8h-007PSm-2O for pgsql-hackers@arkaria.postgresql.org; Tue, 28 Apr 2026 10:58:04 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wHg8f-00Gz8b-0Z for pgsql-hackers@arkaria.postgresql.org; Tue, 28 Apr 2026 10:58:01 +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.96) (envelope-from ) id 1wHg8e-00Gz8S-2p for pgsql-hackers@lists.postgresql.org; Tue, 28 Apr 2026 10:58:00 +0000 Received: from mail-lj1-x231.google.com ([2a00:1450:4864:20::231]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wHg8c-00000003VgK-1p04 for pgsql-hackers@lists.postgresql.org; Tue, 28 Apr 2026 10:58:00 +0000 Received: by mail-lj1-x231.google.com with SMTP id 38308e7fff4ca-38ce8a5bc20so120045351fa.1 for ; Tue, 28 Apr 2026 03:57:57 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1777373877; cv=none; d=google.com; s=arc-20240605; b=Qac4L1W2aFVXQ1XAPC+VeEaQBEocBVO9I24At+A4F0Cd0ozvjqHWJEB8yldT2ZFWu6 cm0qnttNWQpsJZCqKsL2n6mPrUtaX+oJQXhRAAf40B8CX8AgIn6USwp88qKt0B8z0BJl 40fmZhJt+Q8IhRRVuTWm2P7gi75qzS/lXsPYtvxPgjttMMPuuBbwPLhGm1bTjA4R2Hfd IM/0b+9LmRKLzZuPIJPPEzxsLhwBFiXSbAnCaNW+xz1mFeTOYJGy1i8yQ8Zcq4uWyvRb uYwbOo64+qRtB8LbA0LdsRiXA5NhnNxInQoTIpMLIUxHM9a/SLhl5nvVCI5qNDn1NRjo 0HRg== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:dkim-signature; bh=YUgQCsZUi7jCzjqyBc9gVb33qUJCyvH3pQycdm3sT8g=; fh=dcu/fDXRX19uS7xeyvf4/mj9yLwL6ATocnPnKZ23efU=; b=jmTC+u1ibOir4uf7ej54E0dDszQAQTCDNBet7zU5sZi13IkcprJkHed6PI19VVt8N5 NCcRypY5ZAoHa2pLz8vDEtZkIQrAkAv2b4SbSYqCUMCtcQIL7NHAuKn2kwi1nvqKsj18 /wRTEnaNwzqxrUMqkcy84EAajjE/zsP+CRGqyUBsAF2jNgWGRDqaMayU7Zu9+gMTFlIV nn0eYZLF2DLTHLggDks00BDqoTI1eSzrmoQA0pFnQc6eb5RtChR5r5s8W8gnI5iG6ED2 uaJ8MoOokHHlOGrz9DzDNbwl77HzdNLOilh8/uKTbWEQk5OjWCu1MwYKZKCx6GLrfWZH UrBQ==; darn=lists.postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1777373877; x=1777978677; darn=lists.postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=YUgQCsZUi7jCzjqyBc9gVb33qUJCyvH3pQycdm3sT8g=; b=WU5bplhd0R+1O58VO3BTiuVnYETcenMrKx2ofx0u4Uiz2ywhVHNZYOZblBzRD3v3Qz EMKm6XhNFn00edPwrkiI3jmORUdGyol7leOv/3TZ4syIU8xW5TrGf6BORo1Xbky6UaVN /5/3QXdYHmD3DAVAespK8afleBK3zq+JmV4J9E82zhJpYULiC9wzmVF2agqA9adR6d5C mKKt6lakyRTIyADGmv3J7Ll/h6jgicwT7Se/0j0I1fpyNw1iCJrvEUbewqUOdU5vFXLI WL/+oUht3kxOAHEvTzTMPYLrKrSyVCvkSVpOsIZ+bSzSmprHabL6hUq3GiLXJ+4Ozcjp D9tw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1777373877; x=1777978677; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:x-gm-gg:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=YUgQCsZUi7jCzjqyBc9gVb33qUJCyvH3pQycdm3sT8g=; b=PWIo0H5fnb3Dpbi2hvvt2Nc4xWLBTFD2aA49y33r379nFDhXHp2yB8zZiEg3v+M7Jd 63PLXWU2zt6sKPMXcsNFhw2IsNx0aS/1IveBZ2ro2wm9ESjq7N/Cx4JRg2TXOyGA/AhD B+6fddyjxjYFDzywGtgoxvyPDfuSTZqCS9RSTzEK1z5yytlh44IRRt0Ducfe8eS//0vT lmnJ1cpFg0BTStQSWJI0vIcOeRAoD2ncPdzeDYV7vMa2pgPWh3CgUVyHtCBFdTh27cfq wAYstxz5+VcwV/o1v64Hgcs2sBTyLz9kFvlGICQGlMN2FbnYF+gY27xfZEf1zbejDqAA vzJQ== X-Forwarded-Encrypted: i=1; AFNElJ+paJkApcyby72nDZw6sJTDLYADNQZ59ZVIIinBcyxGwVsEd2TM4i+RH5CA2SkdV6vaFhjBccERUDCRpNbm@lists.postgresql.org X-Gm-Message-State: AOJu0Ywml1DUwJBXIR8oUZ6cyRr5Rmkz33yc5F2lx1c/BE37YNpNKdgA r+9EajrXTNjbKxrlsp69oxoNRzL/Avg19Z/K+dk+u/apHFP4lsLQdgjC81cM7XqbQkqzM9jAnTO YoKtESsAnc0XkWJg2vNa7XoeMOJ88MRc= X-Gm-Gg: AeBDietzrEF4VNskEoVxr/OIR/mxZg8PFYvqVlb37aNQIGyXuvXw1mufJ7lHzvH40MF TomOQzlMRqb8rUGm0akzN1psEO8DXZRYcY/4k4m3OW96hSdAjrkVbX2A8e+gTasYsy3M3ELnNK7 6V0OTz7WvGHZNIB3uzVTeVH9ALR1j7FRL8OUf2KoCi9M0WRv42W36apa1Xhrs2zbIOcZt3DpSOf VtMZrC/1zTwYwIPbuSQUlXsy2MhVRLl2fuso9MoSStkhUnDI6PhERPuhlwR91xoJXYP9hWdyY70 85q4R4IiOdhswEK9DUiTNXuELAMwICiIQozZ9DR38ViUbiiPLkI= X-Received: by 2002:a05:651c:2214:b0:38e:a51e:b97b with SMTP id 38308e7fff4ca-39240fe55d4mr9456851fa.23.1777373876825; Tue, 28 Apr 2026 03:57:56 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Amit Kapila Date: Tue, 28 Apr 2026 16:27:45 +0530 X-Gm-Features: AVHnY4K7bwkX3MPFvKTTgZIP-q0H3DpVbcT9mYpZtsSCx1i1lD4xnYR2skM8mas Message-ID: Subject: Re: [PATCH] Fix Int32GetDatum used for bool column in CREATE SUBSCRIPTION To: Nisha Moond Cc: Lakshmi N , "pgsql-hackers@lists.postgresql.org" Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Mon, Apr 27, 2026 at 1:59=E2=80=AFPM Nisha Moond wrote: > > On Mon, Apr 27, 2026 at 11:03=E2=80=AFAM Lakshmi N wrote: > > > > Hi hackers, > > > > In CreateSubscription(), the subretentionactive catalog column (declare= d as > > bool in pg_subscription.h) is populated using Int32GetDatum() instead o= f > > BoolGetDatum(): > > > > This writes 4 bytes into a 1-byte bool Datum. It is inconsistent with t= he > > ALTER SUBSCRIPTION path which correctly uses BoolGetDatum(). > > > > The attached patch fixes this to use BoolGetDatum(), matching both the > > catalog definition and the ALTER path. > > > > +1 > This looks like an oversight in commit a850be2. > Pushed. --=20 With Regards, Amit Kapila.