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 1uGujD-009r4R-T3 for pgsql-bugs@arkaria.postgresql.org; Mon, 19 May 2025 07:16:04 +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 1uGujC-00EDTo-9A for pgsql-bugs@arkaria.postgresql.org; Mon, 19 May 2025 07:16:02 +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 1uGujB-00EDTf-Ub for pgsql-bugs@lists.postgresql.org; Mon, 19 May 2025 07:16:01 +0000 Received: from mail-wr1-x42e.google.com ([2a00:1450:4864:20::42e]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uGuj9-002XDC-0S for pgsql-bugs@lists.postgresql.org; Mon, 19 May 2025 07:16:00 +0000 Received: by mail-wr1-x42e.google.com with SMTP id ffacd0b85a97d-3a0adcc3e54so2620698f8f.1 for ; Mon, 19 May 2025 00:15:59 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec.at; s=google; t=1747638957; x=1748243757; darn=lists.postgresql.org; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:from:to:cc:subject:date :message-id:reply-to; bh=vT4wvBS832/GFHszPVaCnqwSZ4h1PcUFQneLDajO4vw=; b=kGIP8CbbDZ0jFJbaV0LmbNouBvNmissodT7qnpDhg3VuI3SOIaAQQBucw1kbjYvfwk C5sAILuiOY1iL6FA/hjdB9S0P241O91vi5VZRJN6XJ+4WdEaEPnDCF0k7dvEdNDb2dkb smKkkq5h5j+uzESP3W1j/VPNKjIPIfDKbpTHDV2ecPIrc0CuYeASbFM+qPc8d4g/pzMS 2gk/q1MfPyNBP9hlmGBlfSCnY1LxPNJkq5z3SoDPdpwVzqcRWYLezCfHrWN4bO/RKSUV ueey6fUuEJiWWqWI/LvJdnQ4yTfyNxtloYukTiKSY01WPUf8wJr5wxaCBuo/FvmFWeQW 7hmQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1747638957; x=1748243757; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=vT4wvBS832/GFHszPVaCnqwSZ4h1PcUFQneLDajO4vw=; b=SzBErmL6bPRB0hXbwjVFBPPovoASKrL89oGks9Om6LDypALZk/5hLv5BPQO/mjuNXm 6pFsXLmIjuif6Ix3GuQnDMIAigmAgpWF4UWQBcX5jcJOkRy8aWYoGYpynGg8ZB4pwq/f wZl/BlOb8JsIM6DQjdVoCIa+XZrempmlIQLDfjUkXV+U6kUzi6kcgBsIOJ71O17Gm6JV OiM3gUP/Ff6WuV98SXt9eNU/rCU/GiHuHEy2L2XiyZ7+s5SLYjuQM6XlmMPIVeD9PDOO SgEz6ELm4F3oPMdkYkw3q97y/ihIEkOXUXIQickueoknNGyp+ZiFg3cbIJaedjc1gdqd VngQ== X-Forwarded-Encrypted: i=1; AJvYcCUamCt4vhe20ehsiN9EcSGfPpQ+qnu/87CSCNbarbMqyWINQdeqyG1dMPwjtDir31fazWwLhOeve+5w@lists.postgresql.org X-Gm-Message-State: AOJu0Yxyjs+jhhFVMRTiYRUhrp7R6vK7EFHNBCLYELG6Sc1ak13aaIYr qQuOBM36UrsKX/BOdaPJx4lejQ4lpronDGahp7+Mg+OCe0mct0O7TfN3yd1bwOSZQPY= X-Gm-Gg: ASbGncsPlXRCJKbKz8MK/AJOc8aNwCIe5PgzsGZPVfU36p9uBfiTSichvZ9DCDjP9uH MRbdWd2BGqIS8my4JFHTU3SeJeSGh1onVG7HcYrZOdxK30qNHtAbRDVhxoeNW9NbBGJlSJ5A1MX FytF8s7ftbGrntmVd6LDrmoQY646xhpH6przgfKVA7o5emfEwOrTLLeZLOxsCx45hJCmRvbehnm XebI5hVC4TmL3bBXP/5Sw1cg2uyDGTFNcO07rUtHAelDshQP6o1ZhO6trZX9JJx1gwSLoUeISO9 8mc/s2q93ll/Glo2WqAoAUCZeobrnJ3j8ld0qDvjPJFMobK8FXjGn0PjVuqHe2phRRyeCnSvisX 7e0AE X-Google-Smtp-Source: AGHT+IHHaIQIR8d5zR1nFQtSUjRQoN2ldz13Qdq/8+YdOQJuecC7k7ApUHjhPq3qXPJTh9AN+yapeg== X-Received: by 2002:a05:6000:2af:b0:3a1:f5cf:9553 with SMTP id ffacd0b85a97d-3a35fe6628amr9623238f8f.6.1747638957451; Mon, 19 May 2025 00:15:57 -0700 (PDT) Received: from laurenz.albe-K4N0CV00F97414D ([2001:871:5e:822b:3860:ca57:ab3e:b53a]) by smtp.gmail.com with ESMTPSA id 5b1f17b1804b1-442f39ef832sm199533455e9.40.2025.05.19.00.15.57 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Mon, 19 May 2025 00:15:57 -0700 (PDT) Message-ID: <21e42f9bc769d8b863ce660c508c6a50930a504c.camel@cybertec.at> Subject: Re: Understanding JDBC Behaviour From: Laurenz Albe To: Manav Kumar , pgsql-bugs@lists.postgresql.org Date: Mon, 19 May 2025 09:15:56 +0200 In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: base64 User-Agent: Evolution 3.56.1 (3.56.1-1.fc42) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk T24gU2F0LCAyMDI1LTA1LTE3IGF0IDE4OjA1ICswNTMwLCBNYW5hdiBLdW1hciB3cm90ZToKPiBJ J20gd3JpdGluZyB0byBjbGFyaWZ5wqBhIHN5bnRheCB0byBwYXNzIHRoZSBndWMgb3B0aW9ucyBp biB0aGUgc3RhcnR1cCBwYWNrdCBvZiB0aGUgY29ubmVjdGlvbiB2aWEgSkRCQy7CoAo+IAo+IAo+ IFdyb3RlIGJlbG93IHNtYWxsIGphdmEgcHJvZ3JhbToKPiAKPiBQcm9wZXJ0aWVzIHByb3BzID0g bmV3IFByb3BlcnRpZXMoKTsKPiDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqBwcm9wcy5zZXRQcm9w ZXJ0eSgib3B0aW9ucyIsICItYyBEYXRlU3R5bGU9UG9zdGdyZXMsRE1ZIik7Cj4gwqDCoMKgwqDC oMKgwqDCoMKgwqDCoMKgcHJvcHMuc2V0UHJvcGVydHkoInVzZXIiLCAicG9zdGdyZXMiKTsKPiDC oMKgwqDCoMKgwqDCoMKgwqDCoMKgwqBwcm9wcy5zZXRQcm9wZXJ0eSgicGFzc3dvcmQiLCAicG9z dGdyZXMiKTsgCj4gwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgY29ubmVjdGlvbiA9IERyaXZlck1h bmFnZXIuZ2V0Q29ubmVjdGlvbigKPiDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoCJq ZGJjOnBvc3RncmVzcWw6Ly9sb2NhbGhvc3Q6NTQzMi9wb3N0Z3JlcyIsIHByb3BzKTsKPiAKPiDC oMKgwqDCoMKgwqDCoMKgwqDCoMKgwqBzdG10MSA9IGNvbm5lY3Rpb24uY3JlYXRlU3RhdGVtZW50 KCk7Cj4gwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgUmVzdWx0U2V0IHJzID0gc3RtdDEuZXhlY3V0 ZVF1ZXJ5KCJzaG93IERhdGVTdHlsZSIpOwo+IMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoHdoaWxl IChycy5uZXh0KCkpIHsKPiDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoFN5c3RlbS5v dXQucHJpbnRsbihycy5nZXRTdHJpbmcoMSkpOwo+IMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoH0K PiDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqBzdG10MS5leGVjdXRlKCJyZXNldCBEYXRlU3R5bGUi KTsKPiDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqBycyA9IHN0bXQxLmV4ZWN1dGVRdWVyeSgic2hv dyBEYXRlU3R5bGUiKTsKPiDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqB3aGlsZSAocnMubmV4dCgp KSB7Cj4gwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqBTeXN0ZW0ub3V0LnByaW50bG4o cnMuZ2V0U3RyaW5nKDEpKTsKPiDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqB9Cj4gCj4gVGhlIG91 dHB1dCBJJ20gZ2V0dGluZyBpczoKPiBJU08sIERNWQo+IElTTywgRE1ZLgo+IAo+IFJhdGhlciBz aG91bGRuJ3QgdGhlIGV4cGVjdGVkIG91dHB1dCBzaG91bGTCoGJlwqAKPiBQb3N0Z3JlcywgRE1Z Cj4gUG9zdGdyZXMsIERNWSAvL1BsZWFzZSBjb3JyZWN0IG1lIC0gRXZlbiBhZnRlciB0aGUgcmVz ZXQgdGhlIGRlZmF1bHQgdmFsdWUgc2hvdWxkIGJlIFBvc3RncmVzLCBETVkgPwo+IMKgSSBjaGVj a2VkIHRoZSBvZmZpY2lhbCBkb2NzLCBhbmQgZm91bmQgdGhlIHN5bnRheCBhYm92ZS7CoAo+IExv b2tpbmcgZm9yd2FyZCB0byBzZWVpbmcgeW91ciByZXNwb25zZSEgUGxlYXNlIGxldCBtZSBrbm93 IGlmIEkgc2hvdWxkIHBvc3QgZWxzZXdoZXJlLgoKVGhlIGNvcnJlY3QgbGlzdCB3b3VsZCBoYXZl IGJlZW4gcGdzcWwtamRiYywgYnV0IEknbGwgYW5zd2VyIGhlcmUuCgpUaGVyZSBpcyBubyBidWcg aW52b2x2ZWQuICBUaGUgYmVoYXZpb3IgY2FuIGJlIGV4cGxhaW5lZCBhcyBmb2xsb3dzOgoKMS4g VGhlIFBvc3RncmVTUUwgSkRCQyBkcml2ZXIgZm9yY2VzICJEYXRlU3R5bGUiIHRvICJJU08iLCBi ZWNhdXNlIGl0IG5lZWRzIHRoYXQgc2V0dGluZwogICB0byBoYW5kbGUgZGF0ZXMgYW5kIHRpbWVz dGFtcHMgY29ycmVjdGx5LiAgSWYgeW91IG1hbmFnZSB0byBjaGFuZ2UgdGhlIHNldHRpbmcsIHRo ZQogICBkcml2ZXIgd2lsbCBmYWlsIHdpdGggdGhlIGVycm9yIG1lc3NhZ2U6CgogICAgICBUaGUg c2VydmVyJydzIERhdGVTdHlsZSBwYXJhbWV0ZXIgd2FzIGNoYW5nZWQgdG8gLi4uLgogICAgICBU aGUgSkRCQyBkcml2ZXIgcmVxdWlyZXMgRGF0ZVN0eWxlIHRvIGJlZWdpbiB3aXRoIElTTyBmb3Ig Y29ycmVjdCBvcGVyYXRpb24uCgoyLiBSRVNFVCB3aWxsIHJlc2V0IHRoZSBwYXJhbWV0ZXIgdG8g d2hhdCBpdCB3YXMgd2hlbiB0aGUgc2Vzc2lvbiBzdGFydGVkLgoKWW91cnMsCkxhdXJlbnogQWxi ZQo=