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.94.2) (envelope-from ) id 1vGzCf-00AKOQ-P9 for pgsql-hackers@arkaria.postgresql.org; Thu, 06 Nov 2025 12:35:01 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1vGzCd-007ia2-NC for pgsql-hackers@arkaria.postgresql.org; Thu, 06 Nov 2025 12:34:58 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1vGzCd-007iYx-Cv for pgsql-hackers@lists.postgresql.org; Thu, 06 Nov 2025 12:34:58 +0000 Received: from mail-lf1-x132.google.com ([2a00:1450:4864:20::132]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vGzCa-005igl-2p for pgsql-hackers@lists.postgresql.org; Thu, 06 Nov 2025 12:34:57 +0000 Received: by mail-lf1-x132.google.com with SMTP id 2adb3069b0e04-594249d3732so1841084e87.0 for ; Thu, 06 Nov 2025 04:34:56 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1762432495; x=1763037295; darn=lists.postgresql.org; h=content-transfer-encoding:in-reply-to:from:content-language :references:cc:to:subject:user-agent:mime-version:date:message-id :from:to:cc:subject:date:message-id:reply-to; bh=/M0jxMCbzIswl1nnKrSxJwhno1Vh6rjsjz5L7hAtrKI=; b=aGxH6evszeuR8LJJvO3ryjb7fNB9u3tDU1JYTbbO0SkgF+aGq9+/bAkp2Hr5iCiZst C4+XNFN0H+RGL9YPvlzX9+AQQGhX0oUd2lGWh4IDQvoRwb/26QfXJPMQEBrtFQHuFFIG BMj/peErXo/YHRIjtCiDvKNJ1SHrNVAzXbQgTA13dF4Jm49TroeE6/iE6gtGdWEviOfZ PAWisXsN40lEiVeCMEWTDiGNrn/YMEgU0B56B6LOtnwoW1EuLdYlmeejWRQ0oc3XXOij 1YwzrfLxEuewiRMlT3kobPlJqDS121R+aR2OoVhpqfPnktBYYSM1Tuit64alqNCeu78U Czww== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1762432495; x=1763037295; h=content-transfer-encoding:in-reply-to:from:content-language :references:cc:to:subject:user-agent:mime-version:date:message-id :x-gm-gg:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=/M0jxMCbzIswl1nnKrSxJwhno1Vh6rjsjz5L7hAtrKI=; b=hbidjOm5OcoWyJeHByXrgQ7UcXYBJjT+Gi0W9YP8uVdiMi9qXnv8pnbu5DPCXYP641 RxSx8pmCjmqW85SyAhA6rMTrqsT2P44ZjVw17jE3wqVfMAn18NsARhO/6dqqcYs8zRzQ W4EGUH9ZTJAHUZ8bVthKTaL55nbZVrchYTJfx/QkgV4IvUOoAqqHXuHV7uShsxI8+Eo2 PD9bV3+B8pLyB/1uUBzadZcNQT+e76Hm3sPLQgHb3Jbw2P13Zru+6MWXCwwU5o1OVQLt IhIJb/tFeJ6USUf6Zo7Lokb6NrkJGV9kdEtYd33Zk4uQR1LLlRDCf0eJeNknAimcyqnT hU3g== X-Forwarded-Encrypted: i=1; AJvYcCWP6NifRUtMzBvPm8MFEgmhB3R9YqZ3JrUMk0QKEmK6wsUPVyp6Fd0AC+K/4ksZ1O7PAJb0cSYuE5imFywq@lists.postgresql.org X-Gm-Message-State: AOJu0YxZbftkB1cQePpZl0FNWkS2IGPR+ZGs6b1n+FHyQ0SrEgD+cPTC sd15tuLBLiStPocPTZ4GjH8K6YHoOLuJHARDWofA+CkCiRWyqXoNis9J X-Gm-Gg: ASbGnct/ebyIcLQUkp0P0GGUHWJD0ftoiiJADzNJ0yAd8XOFSsMqwqq7Nev8ENW3pgr O5LEhGihd6uFmAarzWD8gSRw6pt/ChUDH6w3aUWTiEaKOs0hW16DCer9pj2n6fs3xxcP8RzOO+6 P9G7jxhkFHYWfJmbmHwim+jSsd/8e3gpMcSQTnSvVbR4/mpEpkJReCRQPD0Ab5xAbMEMgdVB5ta WHYkeE55LY4yhBAezb2Fu8ZEp4449j+GO+CFIpeoYckaUr6Vbdt2bcVJnNc0MNSON4L0G2aH4W+ D+7Q4fpVCaeKI1KvUOpcYbxq4M71K7Q7C8X84F1j6OkPJGqOJo84oJfgdkAjrzbq1Q7vT/FqK52 bYQ0NImgQx5M02KtbqfglRyTLmtgFdey93fTjMAU3XHuEFNx2MbywDqpdUbjKBYFJJkAlBXUWgW Ab+TXk9f4u+Ma+1LsxB+oQDpxz5Ag/vt4mcfCkPUPr0/vJWBW/goU= X-Google-Smtp-Source: AGHT+IEVy9GPUG9IwE+/1OK4jtJs++bV+6dIrV/jP/Yx5YQbz9wzS5pXwxVuJz0zxbH658ZrF4EQJQ== X-Received: by 2002:a05:6512:b9b:b0:594:39c3:b210 with SMTP id 2adb3069b0e04-59449363d43mr1027263e87.18.1762432495001; Thu, 06 Nov 2025 04:34:55 -0800 (PST) Received: from ?IPV6:2a02:aa1:114a:fa1c:3dec:5470:17c7:4bb7? ([2a02:aa1:114a:fa1c:3dec:5470:17c7:4bb7]) by smtp.gmail.com with ESMTPSA id 2adb3069b0e04-5944a5a0004sm688475e87.107.2025.11.06.04.34.54 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Thu, 06 Nov 2025 04:34:54 -0800 (PST) Message-ID: <1f87b8de-9032-46bc-ad0d-382af2c591fb@gmail.com> Date: Thu, 6 Nov 2025 13:34:54 +0100 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Refactor StringInfo usage in subscriptioncmds.c To: Amit Kapila , David Rowley Cc: vignesh C , pgsql-hackers@lists.postgresql.org References: <0b381b02-cab9-41f9-a900-ad6c8d26c1fc@gmail.com> Content-Language: en-US From: Mats Kindahl In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 11/6/25 13:09, Amit Kapila wrote: > On Thu, Nov 6, 2025 at 5:24 PM David Rowley wrote: >> On Fri, 7 Nov 2025 at 00:38, Mats Kindahl wrote: >>> As discussed in [1] the functions check_publications_origin_tables() and >>> check_publications_origin_sequences() are building error messages using >>> dynamically allocated StringInfo instances only to avoid duplicating a >>> call of ereport(). >> Looks better and more traditional to me, plus git diff --stat reports: >> >> 1 file changed, 28 insertions(+), 33 deletions(-) >> >> It has my vote. I've included Vignesh and Amit to see if they're also >> ok with it. >> > LGTM as well. We can avoid doing pfree(pubnames.data) as it is not > allocated in any long term context but I am fine if we want to do it > as there are places where we do such retail pfree as well. I have no strong opinion either way, but since it is not needed and it is not a frequent call it seemed prudent to free it after. Best wishes, Mats Kindahl