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 1u5LqX-00GRoS-NI for pgsql-general@arkaria.postgresql.org; Thu, 17 Apr 2025 09:47:50 +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 1u5LqV-0036IK-8d for pgsql-general@arkaria.postgresql.org; Thu, 17 Apr 2025 09:47:48 +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 1u5LqU-0036IC-Qy for pgsql-general@lists.postgresql.org; Thu, 17 Apr 2025 09:47:47 +0000 Received: from mail-oo1-xc32.google.com ([2607:f8b0:4864:20::c32]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1u5LqT-000WIw-1q for pgsql-general@lists.postgresql.org; Thu, 17 Apr 2025 09:47:46 +0000 Received: by mail-oo1-xc32.google.com with SMTP id 006d021491bc7-601c469cce3so118771eaf.2 for ; Thu, 17 Apr 2025 02:47:45 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1744883265; x=1745488065; 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=0NCfQus85xsI7cvAfg0XJwsJQ/94ffeLXJItN0bow9Q=; b=AaRxdzmXwfwJakeYC1BCZsV8X91W8r8uNtUKdjtwn+00g9fqCRqxJzXPZCEq2MJvsv 5yCu5T/YtiKOe2ukaolEjFm3GHRiOgLKe0Yre1RMVnyY3bAQBCSdUfWvE/t+VFB82hOK XeaQ1Np3KVL/+jVS675PJK+jQdMk62XIXrbPaXsu68zBVy/pkW9f/8M+TAt9aqs7UUqs /KAsu0H7DenXwsBAbalAh/FtNCgb2Axs9g0rjIAsVydO0FjleSMZgV2L5w0Hri6/MR2e 81z4y65lLn2epWxDTHaLmeKo2JhASuu6w3ESq1y93dQDwTvK+WABjSkYwGfxh98mQivR pY6Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1744883265; x=1745488065; h=content-transfer-encoding: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=0NCfQus85xsI7cvAfg0XJwsJQ/94ffeLXJItN0bow9Q=; b=cVwmaUFjYSQyxGy8UQyD90ANeK/YVxW2OcxOWwvWc4rg7wgYxbmxAgnUm1hIUnDBIe ERnY7PpysFsSk9auHozBrO3IWZPy6ybuskr2ysKZaWPB+VKbyFr99uJSaKfA+JGodHqB onlNchlXGTK/pgAMcZNKS77w/BBiTVAH5QQHpGoeG3zJDKJd9F9DHKCriWiHCQ7SVrOo shgi5jeozYY71Gduexv6+DT3wVD6pF5f6tc/CbO0AzpKWMWHbbwLi0aQIvarzzy8Q/Q4 Eme7C0idk7nLZws0+L1aWdfnIlMj5IipIkAGyBveqz/xFBgW6ZDjR1/Gy0Oj5MUPLo0E dzkg== X-Gm-Message-State: AOJu0Yx9BwZRDSXm29SyhNrU1S8C3y67CGg+54eiWot5LZLFwCgohMin EzxVYEaSNPaoPcSw/hc0HmElGvw9o141g/InLdg7mET1Q9YNBpduHzBgCCVt7ivbKLtbAnVchjl EAILUNSpit0ppC33tjALIzhSda9A= X-Gm-Gg: ASbGncsQxxBW5YxqSeZNI2EQ/QHTSAI5vrlVlwY7RhMEc1S1K70vVe+SOXGXWCltExr OjFp+JmE3mvlJidDtuE7yD8XTWJk/7bBAI395xHO8x1VUoW9x/CFUNEq36MVvdeOjE7ZmFfVWpw V70mAV4wkZ1x8avIU3TTjQ0wag X-Google-Smtp-Source: AGHT+IEN8xD0Mvoh6Y+3TwiasWtvEpGEx2EILcdxakDfX6AqlZSukEEKA1gXvjF7zWrVlRIMWmMjnVBVtv8QaXRm0B4= X-Received: by 2002:a05:6820:99c:b0:603:fd3b:aef6 with SMTP id 006d021491bc7-604a93d0638mr2845571eaf.8.1744883265251; Thu, 17 Apr 2025 02:47:45 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Dominique Devienne Date: Thu, 17 Apr 2025 11:47:16 +0200 X-Gm-Features: ATxdqUFCsH9bjfonGUzKiQIa4RVgOTh4jpHA2-uLwDLc-AXrOv5SU8s1LCTrpNs Message-ID: Subject: Re: Request for official clarification on SQL parameter parsing changes in PostgreSQL 15 and 16 To: =?UTF-8?B?546LIOWNmg==?= Cc: "pgsql-general@lists.postgresql.org" , =?UTF-8?B?5p2OIOa1qQ==?= 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 Thu, Apr 17, 2025 at 11:13=E2=80=AFAM =E7=8E=8B=E3=80=80=E5=8D=9A wrote: > Hello PostgreSQL Community, > We have encountered unexpected SQL parsing errors during application upgr= ades from PostgreSQL 14 to 15 and 16, related to the use of JDBC-style para= meter placeholders (`?`) in our legacy applications. AFAIK, PostgreSQL itself only supports $1, $2, ... bind placeholders. Thus I suspect it's your JDBC driver that adds support for ? style placehol= ders. So look in the release notes for that, instead of PostgreSQL itself. --DD