Date: Thu, 04 Sep 2025 19:43:40 +0000
From: Albrecht =?iso-8859-1?b?RHJl3w==?= <albrecht.dress@posteo.de>
Subject: Re: Q: limit the length of log file entries?
To: Adrian Klaver <adrian.klaver@aklaver.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, pgsql-general@lists.postgresql.org
MIME-Version: 1.0
In-Reply-To: <6ec7306b-fa0d-49d1-9944-11cc934b7180@aklaver.com>
Autocrypt: addr=albrecht.dress@posteo.de; prefer-encrypt=mutual; keydata=
 mQENBFZeB1EBCADhnPQMF2jqSiftx8rmkJ042TTo5Dj5zI89g4Ea2rNGrk70GT+g0wVg1r2Z
 dWNN3/BM+Hurm/uKqhlj20peqmpbmAdR2R3avztfAdi0XK1wIyMKzER4z2ieo8mY2yZdcrTt
 jL/P92RHpHMqpITxZBTk5p+TH02LdRgibBglcmc+gN8pF0ZMmMsbGT4J9ytyWXR7xvh+JCBN
 0NRhn8+Rz315bnKZPpGkbKaWwfQUsLwlRalLB2Tvc0nNIoTl1RPBHLIVdR/X4fVg3JJqqfzh
 Jqshmd52PP3oHqNqgPMjHMuvGGQfIOWHifaZxKPyvS9AD+dMFZLFsW6J6Hgfm4YEJ3wtABEB
 AAG0KUFsYnJlY2h0IERyZcOfIDxhbGJyZWNodC5kcmVzc0Bwb3N0ZW8uZGU+iQFRBBMBCgA7
 AhsDBQsJCAcCBhUKCQgLAgQWAgMBAh4BAheAFiEEWb0xPegrNlm4ImZP6kPO+zObgzoFAmO+
 9jYCGQEACgkQ6kPO+zObgzrtpwf/dr6P8QRLHnouFjpfJwN0mcysFU+qfyD22by9yXjsMjg+
 dpFRnH46zsOXuynspiQ1Q+2WZfpzJXX9onIE1dHdaz34Bpg6p6/gzzRILU1R1lAXNcSLlTqq
 PWGi0vu/yckqxEZsjxZLOt+KFlMYQJ/QpT0ejpzzji0Xe1rV7Q1kxOPswiPj5+Cj5gZ784nI
 46cIy9hNOyre4AbolLHmgf3VuXddc9bgfo5P+YgcUXK3oMQslZ+1n/E9VG2T3+4mEO+ElEle
 +pUtZYPauItAP+YMnuy59NdfhtzFm6RmfuPq+jsHtBsO0Fooe7rNs+EXibFLuB4FarJK9rPf
 cN48tTfI+rkBDQRWXgq9AQgA4jjtGwjlY5UcUvaC10WI9hQC5LcCDbiNeJD2B9HSTrBGvoiu
 RaVeYJLLhRUDxQgJ0CJ020dOiV6RMaFU3m8mqhRveY2K/QRA5cQKtds7SVDWAei9lJPFIU8y
 e0/Ub1VBOlDk8h4OEJYa8TK/1iASUzoCS8dPj2F+e3lvIhSJArrUkIsqC+E2kOvhTzk6r21n
 6IIbpraLwwtyRK1r7zhBCaIZOf4jd//Zw8GlKe2fbBC7I8V11HvwUwD6a6t9aJ4qBRwab3z4
 NS6c6pCbRKrEXxRtycRDzNZjsU/WqgsrGaB8/v0PQziyTSK4be4BJ2vG31qveqKadWJF8fOD
 AwxsnQARAQABiQI+BBgBAgAJBQJWXgq9AhsCASkJEOpDzvszm4M6wF0gBBkBAgAGBQJWXgq9
 AAoJEEypbw5n59n4jXEH/Awx/zmVCEyqTWQ69/9kWKDet2xSnl6o7BCoFGip9T6GEwzW6Q0H
 vWH2AB9TD9Y271LL5e4mKObDpPtHC1zVRD1lS6DGeWmqTYQ19XKA4dHyzIhn776FgCzJG0gi
 4n2ASUQTMeLuTEs6PUohUQpw9mYWgEymWaJqKT/7Y3jjV6F+I67zde4wrMG/bb/pbsGqGEyx
 3lisV2NwiCUxLoav+k1atQH608dqX0A8zvoaffepMwpVcPshaJeyxndIFWqSfc9RZ5phK+4Y
 G/mk/p3sRHZAWr+i9/gBJMtfTpmvC2x6zOzAkYDkSrZlV7BlhNJEgRzIY3/dunvlj/chL7ie
 ae+x/wf/YyspQSsHs77yLgRyjYrZP9KsFBAm6ZDfIH0Zv5nwRjEL7hEv/w9lGa6/vgsHZqRz
 8axTls/ob8DuvytcMvV6VG5IZM7MgOI2fmjxWXUygHoDFB4wpW2qTGcWTqEYApdgrqUzUH99
 epmFFwfNZuKQHctTApy8H9rOIdFqCOENs4RzrKqwdt0yEE4FutQ9CbagmOA43rlnQvNP9wLS
 TSOBOPr34bnE1ik4m/viG5WoEjYO58mnEaHoVSXIe/TVazoSha4qKPqd99VU4gc0V54TN2Bt
 O30JRmHQOgMGJT9tjwBLwCOcJ+TxvpT5B5h1b890C6FMwEvTxFM175WDzMqG4bkBDQRWXgxL
 AQgAzTl7tKzNVFWecvxW9VJJXJro3PzIKC8wDVCEqqJ3190yolZ6b5minEDGdvcbJN5reKLL
 /tTXoYRlqFaK5UlBlVha4IcLpjz8YG+VkQFRODY2lDL7Y2cl7BwP1I+0PlgL1IDXkm0+gpGU
 ZYh/3ml2/aWX+o9ObQ5teQAQFjI/UhHWmUMEHBA2bow261Gv6McddHj8hhYaRLqIWuslNAuh
 XOihuo8uSeS220e0awPzhD4bUaUVZ7+6nS8iGbcCVDzV8+yV065uN7BoySxd845k1SYa5wl6
 dNDYauMnSHVqsaJJ0TZhCd6o9B3nm/ox1q/aXBBgVuhbkbUv1sSFkiIrfwARAQABiQEfBBgB
 AgAJBQJWXgxLAhsMAAoJEOpDzvszm4M6v4wIAL+KjjGzeKrnfucLSQjAr90JKh2NllF6jPLI
 96x8nNeVPhcxjpo0DcTiCcO8reRKcLP4clTxKdJXOqjzL03mZ4N5QDTXz1QbyC9xblE3BoHN
 yjsdoJwe2aVRtG2jUs4qjGWx141FkvHtrm/WIh95+YElujqtb3htHjS2rRab8AeIO5H7Mg+i
 fPP4kX7hQ5GOgDXH8uKX3rgZfV3juBLzXOxNGuyotN+tONoHaABeDK2xDKhQiEByA9I5as3N
 YvFnI8ZMAuWKn6yVc6eD0TqRGjDT/LRCqisSuFeQhanx4xpYo0Q+BSHybVPxs3jC587Fapir
 T7Xw36ZsA3NZ/oAySNs=
Message-Id: <574OKSN4.CDETQIBQ.ZESIWSCX@VP6CMSVU.ANT6WK46.P2K35XKE>
Content-Type: multipart/signed; micalg=PGP-SHA512;
	protocol="application/pgp-signature"; boundary="=-m1k2Hl01EXa5Y7EK48RW"
Archived-At: <https://www.postgresql.org/message-id/574OKSN4.CDETQIBQ.ZESIWSCX%40VP6CMSVU.ANT6WK46.P2K35XKE>
Precedence: bulk

--=-m1k2Hl01EXa5Y7EK48RW
Content-Type: text/plain; charset=UTF-8
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

Am 04.09.25 20:21 schrieb(en) Adrian Klaver:
> > "Psycopg 3 sends the query and the parameters to the server separately,=
=20
> > instead of merging them on the client side. Server-side binding works=20
> > for normal SELECT and data manipulation statements (INSERT, UPDATE,=20
> > DELETE), but it doesn=E2=80=99t work with many other statements. For in=
stance,=20
> > it doesn=E2=80=99t work with SET or with NOTIFY:"
>=20
> As example:
>=20
> import psycopg2
> import psycopg
>=20
> conpsyc2 =3D psycopg2.connect("dbname=3Dtest user=3Dpostgres")
> conpsyc3 =3D psycopg.connect("dbname=3Dtest user=3Dpostgres")
>=20
> cur2 =3D conpsyc2.cursor()
> cur3 =3D conpsyc3.cursor()
>=20
> cur2.execute("select * from csv_test where id =3D %s", [1])
> cur3.execute("select * from csv_test where id =3D %s", [1])
>=20
> yields:
>=20
> --cur2
> 2025-09-04 11:17:30.246 PDT [29695] postgres@test LOG:  statement: BEGIN
> 2025-09-04 11:17:30.246 PDT [29695] postgres@test LOG:  statement:=20
> select * from csv_test where id =3D 1
>=20
> --cur3
> 2025-09-04 11:18:07.158 PDT [29703] postgres@test LOG:  statement: BEGIN
> 2025-09-04 11:18:07.159 PDT [29703] postgres@test LOG:  execute=20
> <unnamed>: select * from csv_test where id =3D $1
> 2025-09-04 11:18:07.159 PDT [29703] postgres@test DETAIL:  Parameters:=20
> $1 =3D '1'

Very nice example!  Looks as if the (anyway broken) script should be migrat=
ed to the the newer Python module =E2=80=93 which, looking into the docs, s=
houldn't be too complex=E2=80=A6

Thanks a lot for all your helpful insight,
Albrecht.
--=-m1k2Hl01EXa5Y7EK48RW
Content-Type: application/pgp-signature; name=openpgp-digital-signature.asc
Content-Description: This is a digitally signed message part.

-----BEGIN PGP SIGNATURE-----

iQEzBAABCgAdFiEEcCEPemLFTtyGf4zATKlvDmfn2fgFAmi569UACgkQTKlvDmfn
2fhHKAgAk6/J6Z/eG1ZVU20medI79TQaCu29mRnwPzuVGEJB1h9grhJFVvFe2Znz
ibsHdtVgtfUR+pyzq0JF6kSNU0QX+XZhtktyB9lTUyhMcXQRiLzENvu3o5lf4qiw
1hgyoXkUeTAJGTGhWbRcnbx7Jgu28L5yYfIM0qorvhkBn7bQoXWot3WRagsbO4XP
e4zukx75/da++nX08j8P9/WrtahhYhLdEHw4iBLEqbRVXDZnmWmGg8LYZ+ZvMAIN
oA8njauIGwiS9OPs6BrdwBRCfKtZYfm1n0wBHb9HmKb/9Y6B1Iat5vUffPmXK/9s
miRFk52pB9xFjqWeCOxZPFfkQ904dA==
=t+MN
-----END PGP SIGNATURE-----

--=-m1k2Hl01EXa5Y7EK48RW--