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 1uhxp6-0062Cq-7R for pgsql-bugs@arkaria.postgresql.org; Fri, 01 Aug 2025 22:01:56 +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 1uhxp5-009dLC-2Z for pgsql-bugs@arkaria.postgresql.org; Fri, 01 Aug 2025 22:01:55 +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.94.2) (envelope-from ) id 1uhxp4-009dL2-Qr for pgsql-bugs@lists.postgresql.org; Fri, 01 Aug 2025 22:01:54 +0000 Received: from mail-io1-xd2b.google.com ([2607:f8b0:4864:20::d2b]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uhxp2-000H9U-2H for pgsql-bugs@lists.postgresql.org; Fri, 01 Aug 2025 22:01:54 +0000 Received: by mail-io1-xd2b.google.com with SMTP id ca18e2360f4ac-87c0bb1ee4eso32683839f.2 for ; Fri, 01 Aug 2025 15:01:52 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1754085710; x=1754690510; darn=lists.postgresql.org; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:from:to:cc:subject:date:message-id:reply-to; bh=xkvwS2FpITzDjtor3yJVBFOud6reNf4QMqyBv+bPU+Q=; b=bncaIEqlmaBFt+We8USPGaiiifSj/xgqxWrGOIfq1lGJ2eAdSZuaXLeaFsJaeUa9Ly W5yrEj/Rbi4GSiNYYaBk37PN+agbi63baitLUW7p4fu3Yry4OMKKdmiagpsKlLCbVfpW AWqafNVyHlEwcZ7SFyOfRnMwfdR3ziaLsaSe4BOg1l6prKg/7E4Aa7zMwWBiQhgdqydw 8ZUa0MUTzL2DANgCLc/CDIACuOGLxXo38XByoyI7egF9FRkvCrRG61T8WENTlujX67RJ jQBAx+IflcwyGcsSlCRscXfXjVGWXAQUtP3LMHliSkNeDxCBb/MGuCBeO2d3F/qJwGax /NHQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1754085710; x=1754690510; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=xkvwS2FpITzDjtor3yJVBFOud6reNf4QMqyBv+bPU+Q=; b=G11pVDYumH06OazzDebCJPk5Ey4YYRBOwV5Zm20HTAOx08X0PNIbvbz1q7iBv8d7iU LCR4N0TVegFROELwbyqz8Ykmef4ddn0jSkkzdmTt4wQ6CTQli+kVH+fnQFJd7pj/y8Vd 6r8WjKwt5EsuRzMqc39dabsfYLeoHH0roOnhBY4lAuAoeS0LHf5q14ymQ/9Pk6QGy2Fm 0tNllUcuccGD2v2xH136lXFibV0C+OS/vcYIRjhLVOucOUZMpuAtp33iJb4jCZtj5uS0 GUYVZ8Lj96RRT/Sh6nCvnVhr6/6U1BqUXzaZqShdJzODj3rTedwCjbUC8cIJBcKGcM7z wAfQ== X-Forwarded-Encrypted: i=1; AJvYcCVNGycoPlRueO4/kcr+OFm0wIGBkqRZ/uGhGTgWMJfqrrosDCc2Z8ZbgK1IG8MXEcv0LXl11hXrKVfg@lists.postgresql.org X-Gm-Message-State: AOJu0YzXt5z+t2fF6akEiWzTgFsXeqRHEilepKVwcfwEsURA9KlCqV8b A7fUf9hEXxbgtRCtuSq+2lNDNnfzBlLNPgEQCPJBjmAJHGaxtNz0JRV8 X-Gm-Gg: ASbGncusK7eUrLtEp11iGqpnL6fNvF6Jw6nmAykoTZ4jxwm3BkjT0FqZWj3ZDs7ddDH OtQ8J5nbIF8sTrvHvOjWnDMnRvgblWoP9P0Nycf7LOJa0FqeZah03lNmvhDG70+Fs1GFWKZTfRK LSezc/MgqGuPGxyzRrot9CT0XV3c5jwGN6RzvfJXauwi52PzfoFipHPEDf5s5pU2YU9pNqB/vAa cXJZOkpMuyLItBbvFlJrQvH5IlZCAzRG/ZiYmAgMCeSzBkRFRNXklC9MxODZnWRu6GvQfUrheuk AXcxl3sIv7X0r2iA7+EZeWKJ+OSRspJpD/h/UMNv6hR318p62YNF4g59dQuRPqjRyFMBPwO9BgQ awRtQqciWRG4nS0Xs9iFC7S/E88U613ty6EmPoH1CBguAw6EE+Wy7UocqBWDvTkhcg3/THRwBXb HMugaSLZj2cHWB X-Google-Smtp-Source: AGHT+IH1EyFKlY5tjI+bVO5AMDCv1SVRIF829HqNS0ce4LEvU2SjaJQXM6wyg3vug/cPgLCJfuAcSA== X-Received: by 2002:a6b:4407:0:b0:87c:1542:8abc with SMTP id ca18e2360f4ac-88168327309mr211002939f.4.1754085710356; Fri, 01 Aug 2025 15:01:50 -0700 (PDT) Received: from nathan (162-195-168-172.lightspeed.stlsmo.sbcglobal.net. [162.195.168.172]) by smtp.gmail.com with ESMTPSA id ca18e2360f4ac-8814dfaf30bsm142974739f.29.2025.08.01.15.01.49 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Fri, 01 Aug 2025 15:01:49 -0700 (PDT) Date: Fri, 1 Aug 2025 17:01:47 -0500 From: Nathan Bossart To: Tom Lane Cc: Laurenz Albe , mert@futo.org, pgsql-bugs@lists.postgresql.org Subject: Re: BUG #18964: `ALTER DATABASE ... RESET ...` fails to reset extension parameters that no longer exist Message-ID: References: <803ddef427b9016be04af9320925e9570d3fcc06.camel@cybertec.at> <8902b6f8d5c19f09f4a052295b9de41d9f6970b5.camel@cybertec.at> <768341.1753738070@sss.pgh.pa.us> 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 Committed. On Wed, Jul 30, 2025 at 02:13:16PM -0500, Nathan Bossart wrote: > It applies relatively cleanly down to v15. The only thing I had to change > was to replace guc_free() with free() on v15. I was a little worried about > changing the signature of check_GUC_name_for_parameter_acl(), but > codesearch.debian.net doesn't show any outside uses. I ended up skipping the back-patch of commit 2d870b4 to avoid the ABI breakage. That means ALTER SYSTEM remains broken for this use-case on v15 and v16, but IIUC it's already pretty broken in this area, so I'm not sure we care too much. -- nathan