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 1tLTnm-00F3HB-Fo for pgsql-bugs@arkaria.postgresql.org; Wed, 11 Dec 2024 20:59:22 +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 1tLTnj-002cx9-PC for pgsql-bugs@arkaria.postgresql.org; Wed, 11 Dec 2024 20:59:20 +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 1tLTnj-002cw0-G9 for pgsql-bugs@lists.postgresql.org; Wed, 11 Dec 2024 20:59:20 +0000 Received: from mail-io1-xd2b.google.com ([2607:f8b0:4864:20::d2b]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1tLTni-002KKk-Cf for pgsql-bugs@lists.postgresql.org; Wed, 11 Dec 2024 20:59:19 +0000 Received: by mail-io1-xd2b.google.com with SMTP id ca18e2360f4ac-844c63330d7so68916539f.0 for ; Wed, 11 Dec 2024 12:59:18 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1733950757; x=1734555557; darn=lists.postgresql.org; h=in-reply-to:content-transfer-encoding:content-disposition :mime-version:references:message-id:subject:cc:to:from:date:from:to :cc:subject:date:message-id:reply-to; bh=9N72JJo7RHqZbc5cQFR6sRAyX5QrB4uvQ5/ALTt5+8Y=; b=NREbFWz9Xs1aPl1WsUK5/ADznJUMzJ2EdXRfZwHHQwDdpyEwANpbE/HOXy0jmHd+QX SMPfr5Ixc7EElGcSi0uAUstIBBLY5Iv7FZtmn3V+eFn6Y0xvZDJWkDm5TH2c2PhgOyXF 2Hv+u+pt5ortvKabPtaRtWr4F6jfm/uUi6zW7UY6w4u9RRgb39GoHzApQqemORN4T2tU QdjDFILoYyKhobMnGItVj2d+g3/Msm+Lkl4BDnOxB2zvP7JLSEbsG8cD58B+0dtr92ia bpRDTZHEKdao46W0Kqhe7trC94qrib/OXdUVnmIoCfsGnFJgUhPQk7Kp2dwB9Y0wM0B7 tkaw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1733950757; x=1734555557; h=in-reply-to:content-transfer-encoding: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=9N72JJo7RHqZbc5cQFR6sRAyX5QrB4uvQ5/ALTt5+8Y=; b=SBjLSjOHfPRW9o+Z+fEZ74Y3ZirhxjwmcpGGawJE/giAk9Tw0vrmKmhIHKp1+Hps7N eYjUw/MfJeN8G9fpaXDigg+roHDVsT+l74AmlKbCRaeX3jm+gzX4ONjLNCvSKvIys7G7 3LCa1LroweAqRi1mnIgB6qNQECNm94E3IjHUAc3oEwwG6Ubjj+BD4BEnajqiVu5/MHYc pvzXm2RsTHwF2XOz8aBj7TU7YvtzKJuk5MfusT6vBvlaww5olGfWZbWD7CBt9yBEzXiD j7bjJBV7rY2n9Mz/CnSn+MqdtB+JyrkNqQuIpEbnKeH49t0ieWC0hhWYfWLGWvX8Q4pH WZkg== X-Forwarded-Encrypted: i=1; AJvYcCWH+lAWkBl2H3OFyHC8CJbKPRuh96miNbgoYH+KARv0IuVd3D8oQbuBXnPGWBiIMsTgOWKso/ztLHB3@lists.postgresql.org X-Gm-Message-State: AOJu0Yw26+4VT4mi5fsasRsCBxVyOhd/yKWQb3rToSCbrD9AMd8QXJ5o cYKRphluFwLC12U7DAEilVYGysRtV0zqrRi+lFtpBGSHadEZAsBU X-Gm-Gg: ASbGncsXao4yCqDcZm/rdMql7rwiDrG4tyqmachx6rMa7R39LkLRSDVHPQtgfglhwdE OgeAPQnHLHosNnOyowUtz5FjvOTkx299K5lM7ZsharOryCd2+IEgRMJOQzZKH2vXYDYELhS7UZM 4xzpGdnn1NrWx9bF/2HNbLYNjC7EvyoDBNx+94sX0QRFXMfe+/X/IXUIW6mOdCkLAatzOV4Vdpv nFX1UHy2kD5v8+G3FZQAhCMx/JDlSKfaQ+WTMgNNRuWrQv7SlqomS5qVsfLrMz7hiTsDMyEtuDj H53SC+RxIF6utqVesD0q4i1oRCLRWVNCv3prYIiNB9Fv X-Google-Smtp-Source: AGHT+IGA6LlAOIZN4NaSBTqeQZA9UPQ6G9rpvhqKoBrxyIUXSWen8kO08AAkqnghdXZmAuktRNOzWQ== X-Received: by 2002:a92:ca4c:0:b0:3a7:6c5c:9aa4 with SMTP id e9e14a558f8ab-3ac48caa403mr12787875ab.12.1733950757164; Wed, 11 Dec 2024 12:59:17 -0800 (PST) Received: from nathan (162-195-168-172.lightspeed.stlsmo.sbcglobal.net. [162.195.168.172]) by smtp.gmail.com with ESMTPSA id 8926c6da1cb9f-4e2ca310d73sm1308692173.117.2024.12.11.12.59.16 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 11 Dec 2024 12:59:16 -0800 (PST) Date: Wed, 11 Dec 2024 14:59:15 -0600 From: Nathan Bossart To: Thomas Munro Cc: Bertrand Drouvot , Tom Lane , Bruce Momjian , adam@labkey.com, pgsql-bugs@lists.postgresql.org Subject: Re: BUG #18711: Attempting a connection with a database name longer than 63 characters now fails Message-ID: References: <1865227.1732723416@sss.pgh.pa.us> <2094158.1732812306@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Tue, Dec 03, 2024 at 09:03:55PM +1300, Thomas Munro wrote: > On Tue, Dec 3, 2024 at 8:38 PM Bertrand Drouvot > wrote: >> Maybe we can try an "hybrid" approach that could simplify the AlterSystemCatalogEncoding() >> by relying on a new struct, say: > > Interesting idea, yeah, I'll look into that. > >> Do you think it's worth to move the discussion into a dedicated hackers thread? >> (maybe reaching a wider audience?) I think the subject is sensible enough. > > Ok yeah, I'll start a new thread on -hackers soon. If we are leaning towards a more comprehensive fix in v18, ISTM we should go ahead and revert commit 562bee0 (both for master and v17). Or am I misinterpreting the proposed path forward here? -- nathan