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 1uOv4q-00Ddo1-Tu for pgsql-general@arkaria.postgresql.org; Tue, 10 Jun 2025 09:15:29 +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 1uOv4n-002KB0-Nl for pgsql-general@arkaria.postgresql.org; Tue, 10 Jun 2025 09:15:26 +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 1uOv4n-002KAr-BF for pgsql-general@lists.postgresql.org; Tue, 10 Jun 2025 09:15:26 +0000 Received: from mail-ed1-x530.google.com ([2a00:1450:4864:20::530]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uOv4j-001D5I-1F for pgsql-general@lists.postgresql.org; Tue, 10 Jun 2025 09:15:22 +0000 Received: by mail-ed1-x530.google.com with SMTP id 4fb4d7f45d1cf-607434e1821so5868678a12.0 for ; Tue, 10 Jun 2025 02:15:20 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec.at; s=google; t=1749546919; x=1750151719; darn=lists.postgresql.org; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:from:to:cc:subject :date:message-id:reply-to; bh=N8YfzDmlWPFUOLNsGQZ8HliVvvP6wKNokBPxG5pP2z4=; b=qqsPFmed3Cyg9v/pSVw9pVDHWSZeYh1r9AeuHgDJBtvNxXFVKo+EZ5EMTFXQbhLyWW 54lyKLOjMqrH7Z4wlJomCCYRqOKhGXS4Qy86Py0eAF/hTQpd2BHOShngiYr4HQzpvfH4 SJ73YdJS961vnputcM617V9t9pHQ0gh2s3KQ7oWqUtOZ0SGiQ3moUex9eFapMGSyI056 QzJ/0owFb8xUzZ5cd+m9f+34J9KMt3yiQ9s3apge1UJ4A0s8PdhhaI1tfnGsmmspWH4m oweyRd9Fo3W7spRXLgsyC9qO53mf9Y2csMDABzOjWXAXAfGilRM+wZ9qNvZrGjzkOag8 XVEQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1749546919; x=1750151719; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=N8YfzDmlWPFUOLNsGQZ8HliVvvP6wKNokBPxG5pP2z4=; b=BottpxUpcFjywKQlF4dk7N9jad74jcXQ8NxRMxgaMH+PU2o+/T8TNk8jLTzKwEdR30 oeCCkL48fODubBvMvdq2sgMGUQhZa6VcWgJv20rt+jk5gncN+Wcul7PU15oaDCBNWiaa VfAYRvVj4czeXK7QhRhWJwmUHtZDqzdPjFXTsbBfxxXLPrmRm1INboGXuKLC6MPqfNmo mhPz6ggG4pOvbPUILRJxbT+XBrVQwLzgoBXMCS1t1qJLQf10oTI/ThhtumJTqQbPHlCY sg1lWBtjcpAC6R5EXtXyEfoJDeBleF+N/yblC6lijwSjlFNKOLf+TASE/XKjKgmWo6lc N9gw== X-Forwarded-Encrypted: i=1; AJvYcCVCh651R3T+acXdepQDUjY3F5iDQQu/WLUhu56Y/w1QXqdhIiv0Oo7MUXfzXcBNnkTpoTDb+iriotK3rG0T@lists.postgresql.org X-Gm-Message-State: AOJu0YzOVMXsxf89ASLyzVwTyiiLj+L/HrGEbPF0T3pWKfYAADIoPARp rzSxHBBe6MY/oENgCv0+9JBsTicAc0tLsuM+u/PNGFjymkV4Tiing+Aki8QxEBKws/Q= X-Gm-Gg: ASbGncvRzKs52szIS5ojjjfTVyXFcOmh3kWZhbqLsEJC7zMvcQcF7i99oN5lUi8Y4cu PHuPih3ea68CDYg2ZJG4DH/TPeKMxWZ+UgGDPLudUmKupIp+nVyw52zaNbrPAOJxu3jzftAAgPq uSOqk4gDRUzPKtNUnWaTib9IvGEAII1IEkB4KOdaI5QB/tnJXR/Yf9tuM8d3B5X7YdlEhSIJYGf RCFIPPpRpYwDra2d/3r5jVCZQA2HwivZb4NCjzYPW5e3Ertkp4uZHQjsHruWDGYd2awE/Pu1DZA 1/0tcLZIwBhCRK7uhezWT+M2OWXVxEHW3pT1phzI5ajwNerjD1e6RXR+ajVlW6XXkAcjLTcDNej EdaJOmibHVfwoZN0= X-Google-Smtp-Source: AGHT+IGVqAdATDpBLy0/N4GM2twpHFAtQIskncDxLmYJ+SiMhc/7I3S04RzZKIX1SqqgJEch1WFJWA== X-Received: by 2002:a05:600c:3e0f:b0:450:d3c6:84d8 with SMTP id 5b1f17b1804b1-45201460b91mr142941055e9.14.1749545247351; Tue, 10 Jun 2025 01:47:27 -0700 (PDT) Received: from laurenz.albe-K4N0CV00F97414D ([2001:871:5e:1fcb:8220:6edb:4779:100b]) by smtp.gmail.com with ESMTPSA id 5b1f17b1804b1-45209bc7391sm137113795e9.7.2025.06.10.01.47.26 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Tue, 10 Jun 2025 01:47:27 -0700 (PDT) Message-ID: Subject: Re: Feature request: Settings to disable comments and multiple statements in a connection From: Laurenz Albe To: Dominique Devienne , Tom Lane Cc: Glen K , "pgsql-general@lists.postgresql.org" Date: Tue, 10 Jun 2025 10:47:24 +0200 In-Reply-To: References: <1079732.1749078352@sss.pgh.pa.us> Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.56.2 (3.56.2-1.fc42) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Tue, 2025-06-10 at 10:02 +0200, Dominique Devienne wrote: > On Thu, Jun 5, 2025 at 1:06=E2=80=AFAM Tom Lane wrote= : > > > Provide a client connection option (and/or implement the backend supp= ort) to allow only one statement in an execute request > >=20 > > This exists already; you just have to use the extended query protocol. >=20 > Hi Tom. Can you be more specific please? > In the context of LibPQ, in case it matters. PQexecParams() Yours, Laurenz Albe