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 1v698s-00HZg4-Nk for pgsql-committers@arkaria.postgresql.org; Tue, 07 Oct 2025 14:58:18 +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 1v698q-000bTX-H2 for pgsql-committers@arkaria.postgresql.org; Tue, 07 Oct 2025 14:58:17 +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 1v698q-000bTL-9x for pgsql-committers@lists.postgresql.org; Tue, 07 Oct 2025 14:58:17 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1v698j-000sOZ-1x for pgsql-committers@lists.postgresql.org; Tue, 07 Oct 2025 14:58:11 +0000 Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1v698i-001SzY-2x for pgsql-committers@lists.postgresql.org; Tue, 07 Oct 2025 14:58:08 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1v698h-000WXJ-2F for pgsql-committers@lists.postgresql.org; Tue, 07 Oct 2025 14:58:07 +0000 Content-Type: multipart/mixed; boundary="===============1231800999883792698==" MIME-Version: 1.0 From: Tom Lane To: pgsql-committers@lists.postgresql.org Subject: pgsql: Improve psql's ability to select pager mode accurately. X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Tue, 07 Oct 2025 14:58:07 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============1231800999883792698== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 SW1wcm92ZSBwc3FsJ3MgYWJpbGl0eSB0byBzZWxlY3QgcGFnZXIgbW9kZSBhY2N1cmF0ZWx5LgoK V2UgdHJ5IHRvIHVzZSB0aGUgcGFnZXIgb25seSB3aGVuIG1vcmUgdGhhbiBhIHNjcmVlbmZ1bCdz IHdvcnRoIG9mCmRhdGEgaXMgdG8gYmUgcHJpbnRlZC4gIEhvd2V2ZXIsIHRoZSBjb2RlIGluIHBy aW50LmMgdGhhdCdzIGNvbmNlcm5lZAp3aXRoIGNvdW50aW5nIHRoZSBudW1iZXIgb2YgbGluZXMg dGhhdCB3aWxsIGJlIG5lZWRlZCBtaXNzZWQgYSBsb3Qgb2YKZWRnZSBjYXNlczoKCiogV2hpbGUg cGxhaW4gYWxpZ25lZCBtb2RlIGFjY291bnRlZCBmb3IgZW1iZWRkZWQgbmV3bGluZXMgaW4gY29s dW1uCmhlYWRlcnMgYW5kIHRhYmxlIGNlbGxzLCB1bmFsaWduZWQgYW5kIHZlcnRpY2FsIG91dHB1 dCBtb2RlcyBkaWQgbm90LgoKKiBJbiBwYXJ0aWN1bGFyLCBzaW5jZSB2ZXJ0aWNhbCBtb2RlIHJl cGVhdHMgdGhlIGhlYWRlcnMgZm9yIGVhY2gKcmVjb3JkLCB3ZSBuZWVkIHRvIGFjY291bnQgZm9y IGVtYmVkZGVkIG5ld2xpbmVzIGluIHRoZSBoZWFkZXJzIGZvcgplYWNoIHJlY29yZC4KCiogTXVs dGktbGluZSB0YWJsZSB0aXRsZXMgd2VyZSBub3QgYWNjb3VudGVkIGZvci4KCiogdHVwbGVzX29u bHkgbW9kZSAod2hlcmUgaGVhZGVycyBhcmVuJ3QgcHJpbnRlZCkgd2Fzbid0IGFjY291bnRlZApm b3IuCgoqIEZvb3RlcnMgd2VyZSBhY2NvdW50ZWQgZm9yIGFzIG9uZSBsaW5lIHBlciBmb290ZXIs IGFnYWluIG1pc3NpbmcKdGhlIHBvc3NpYmlsaXR5IG9mIG11bHRpLWxpbmUgZm9vdGVycy4gIChJ biBzb21lIGNhc2VzIHN1Y2ggYXMKIlxkKyIgb24gYSB2aWV3LCB0aGVyZSBjYW4gYmUgbWFueSBs aW5lcyBpbiBhIGZvb3Rlci4pICBBbHNvLAp3ZSBmYWlsZWQgdG8gYWNjb3VudCBmb3IgdGhlIGRl ZmF1bHQgZm9vdGVyLgoKVG8gZml4LCBtb3ZlIHRoZSBlbnRpcmUgcmVzcG9uc2liaWxpdHkgZm9y IGNvdW50aW5nIGxpbmVzIGludG8KSXNQYWdlck5lZWRlZCAob3IgYWN0dWFsbHksIGludG8gYSBu ZXcgc3Vicm91dGluZSBjb3VudF90YWJsZV9saW5lcyksCmFuZCB0aGVuIGV4cGFuZCB0aGUgbG9n aWMgYXMgYXBwcm9wcmlhdGUuICBBbHNvIHJlc3RydWN0dXJlIHRvIG1ha2UgaXQKcGVyaGFwcyBh IGJpdCBlYXNpZXIgdG8gZm9sbG93LiAgSXQncyBzdGlsbCBvbmx5IGNvbXBsZXRlbHkgYWNjdXJh dGUKZm9yIEFMSUdORUQvV1JBUFBFRC9VTkFMSUdORUQgZm9ybWF0cywgYnV0IHRoZSBvdGhlciBm b3JtYXRzIGFyZSBub3QKdHlwaWNhbGx5IHVzZWQgd2l0aCBpbnRlcmFjdGl2ZSBvdXRwdXQuCgpB cnJhbmdlIHRvIG5vdCBydW4gY291bnRfdGFibGVfbGluZXMgYXQgYWxsIHVubGVzcyB3ZSB3aWxs IHVzZQppdHMgcmVzdWx0LCBhbmQgdGVhY2ggaXQgdG8gcXVpdCBlYXJseSBhcyBzb29uIGFzIGl0 J3MgcHJvdmVuCnRoYXQgdGhlIG91dHB1dCBpcyBsb25nIGVub3VnaCB0byByZXF1aXJlIHVzZSBv ZiB0aGUgcGFnZXIuCldoZW4gZGVhbGluZyB3aXRoIGxhcmdlIHRhYmxlcyB0aGlzIHNob3VsZCBz YXZlIGEgbm90aWNlYWJsZQphbW91bnQgb2YgdGltZSwgc2luY2UgcGdfd2Nzc2l6ZSgpIGlzbid0 IGV4YWN0bHkgY2hlYXAuCgpJbiBwYXNzaW5nLCBtb3ZlIHRoZSAiZmxvZyIgb3V0cHV0IHN0ZXAg dG8gdGhlIGJvdHRvbSBvZiBwcmludFRhYmxlKCksCnJhdGhlciB0aGFuIHJ1bm5pbmcgaXQgd2hl biB3ZSd2ZSBhbHJlYWR5IG9wZW5lZCB0aGUgcGFnZXIgaW4gc29tZQptb2Rlcy4gIEluIHByaW5j aXBsZSBpdCBzaG91bGRuJ3QgaW50ZXJmZXJlIHdpdGggdGhlIHBhZ2VyIGJlY2F1c2UKZmxvZyBz aG91bGQgYWx3YXlzIHBvaW50IHRvIGEgbm9uLWludGVyYWN0aXZlIGZpbGU7IGJ1dCBpdCBzZWVt cyBzaWxseQp0byByaXNrIGFueSBpbnRlcmZlcmVuY2UsIGVzcGVjaWFsbHkgd2hlbiB0aGUgZXhp c3RpbmcgcG9zaXRpb25pbmcKc2VlbXMgdG8gaGF2ZSBiZWVuIGNob3NlbiB3aXRoIHRoZSBhaWQg b2YgYSBkYXJ0Ym9hcmQuCgpBbHNvIGFkZCBhIFRBUCB0ZXN0IHRvIGV4ZXJjaXNlIHBhZ2VyIG1v ZGUuICBVcCB0byBub3csIHdlIGhhdmUgaGFkCnplcm8gdGVzdCBjb3ZlcmFnZSBvZiB0aGVzZSBj b2RlIHBhdGhzLCBiZWNhdXNlIHRoZXkgYXJlbid0IHJlYWNoZWQKdW5sZXNzIGlzYXR0eShzdGRv dXQpLiAgV2UgZG8gaGF2ZSB0aGUgdGVzdCBpbmZyYXN0cnVjdHVyZSB0byBpbXByb3ZlCnRoYXQg c2l0dWF0aW9uLCB0aG91Z2guICBGb2xsb3dpbmcgdGhlIGxlYWQgb2YgMDEwX3RhYl9jb21wbGV0 aW9uLnBsLApzZXQgdXAgYW4gaW50ZXJhY3RpdmUgcHNxbCBhbmQgZmVlZCBpdCBzb21lIHRlc3Qg Y2FzZXMuICBUbyBkZXRlY3QKd2hldGhlciBpdCByZWFsbHkgZGlkIGludm9rZSB0aGUgcGFnZXIs IHBvaW50IFBTUUxfUEFHRVIgdG8gIndjIC1sIi4KVGhlIHRlc3QgaXMgc2tpcHBlZCBpZiB0aGF0 IHV0aWxpdHkgaXNuJ3QgYXZhaWxhYmxlLgoKQXV0aG9yOiBFcmlrIFdpZW5ob2xkIDxld2llQGV3 aWUubmFtZT4KVGVzdC1hdXRob3JlZC1ieTogVG9tIExhbmUgPHRnbEBzc3MucGdoLnBhLnVzPgpS ZXZpZXdlZC1ieTogVG9tIExhbmUgPHRnbEBzc3MucGdoLnBhLnVzPgpEaXNjdXNzaW9uOiBodHRw czovL3Bvc3Rnci5lcy9tLzJkZDI0MzBmLWRkMjAtNGM4OS05N2ZkLTI0MjYxNmEzZDc2OEBld2ll Lm5hbWUKCkJyYW5jaAotLS0tLS0KbWFzdGVyCgpEZXRhaWxzCi0tLS0tLS0KaHR0cHM6Ly9naXQu cG9zdGdyZXNxbC5vcmcvcGcvY29tbWl0ZGlmZi8yN2RhMWE3OTZmZjlhMzY3YzM0ZDQzMWZkMjhi ZTkyM2NkOGRhNTA3CgpNb2RpZmllZCBGaWxlcwotLS0tLS0tLS0tLS0tLQpzcmMvYmluL3BzcWwv bWVzb24uYnVpbGQgICAgfCAgIDEgKwpzcmMvYmluL3BzcWwvdC8wMzBfcGFnZXIucGwgfCAxMDQg KysrKysrKysrKysrKwpzcmMvZmVfdXRpbHMvcHJpbnQuYyAgICAgICAgfCAzNjEgKysrKysrKysr KysrKysrKysrKysrKysrKysrKysrKysrLS0tLS0tLS0tLS0KMyBmaWxlcyBjaGFuZ2VkLCAzODIg aW5zZXJ0aW9ucygrKSwgODQgZGVsZXRpb25zKC0pCgo= --===============1231800999883792698==--