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.96) (envelope-from ) id 1vNebo-00A0F6-39 for pgsql-committers@arkaria.postgresql.org; Mon, 24 Nov 2025 22:00:32 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vNebn-004vBG-1Y for pgsql-committers@arkaria.postgresql.org; Mon, 24 Nov 2025 22:00:31 +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.96) (envelope-from ) id 1vNebn-004vB8-0r for pgsql-committers@lists.postgresql.org; Mon, 24 Nov 2025 22:00:31 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vNebk-001H7T-2a for pgsql-committers@lists.postgresql.org; Mon, 24 Nov 2025 22:00:30 +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.96) (envelope-from ) id 1vNebl-000FgH-19 for pgsql-committers@lists.postgresql.org; Mon, 24 Nov 2025 22:00:29 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vNebk-001EcF-2D for pgsql-committers@lists.postgresql.org; Mon, 24 Nov 2025 22:00:29 +0000 Content-Type: multipart/mixed; boundary="===============7928388879846992246==" MIME-Version: 1.0 From: Tom Lane To: pgsql-committers@lists.postgresql.org Subject: pgsql: Improve detection of implicitly-temporary views. X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Mon, 24 Nov 2025 22:00:29 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============7928388879846992246== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 SW1wcm92ZSBkZXRlY3Rpb24gb2YgaW1wbGljaXRseS10ZW1wb3Jhcnkgdmlld3MuCgpXZSd2ZSBs b25nIGhhZCBhIHByYWN0aWNlIG9mIG1ha2luZyB2aWV3cyB0ZW1wb3JhcnkgYnkgZGVmYXVsdCBp ZiB0aGV5CnJlZmVyZW5jZSBhbnkgdGVtcG9yYXJ5IHRhYmxlcy4gIEhvd2V2ZXIgdGhlIGltcGxl bWVudGF0aW9uIHdhcyBwcmV0dHkKaW5jb21wbGV0ZSwgaW4gdGhhdCBpdCBvbmx5IHNlYXJjaGVk IGZvciBSYW5nZVRibEVudHJ5IHJlZmVyZW5jZXMgdG8KdGVtcCByZWxhdGlvbnMuICBVc2VzIG9m IHRlbXBvcmFyeSB0eXBlcywgcmVnY2xhc3MgY29uc3RhbnRzLCBldGMKd2VyZSBub3QgZGV0ZWN0 ZWQgZXZlbiB0aG91Z2ggdGhlIGRlcGVuZGVuY3kgbWVjaGFuaXNtIGNvbnNpZGVycyB0aGVtCmdy b3VuZHMgZm9yIGRyb3BwaW5nIHRoZSB2aWV3LiAgVGh1cyBhIHZpZXcgbm90IGJlbGlldmVkIHRv IGJlIHRlbXAKY291bGQgc2lsZW50bHkgZ28gYXdheSBhdCBzZXNzaW9uIGV4aXQgYW55aG93LgoK VG8gaW1wcm92ZSBtYXR0ZXJzLCByZXBsYWNlIHRoZSBhZC1ob2MgaXNRdWVyeVVzaW5nVGVtcFJl bGF0aW9uKCkKbG9naWMgd2l0aCB1c2Ugb2YgdGhlIGRlcGVuZGVuY3ktYmFzZWQgaW5mcmFzdHJ1 Y3R1cmUgaW50cm9kdWNlZCBieQpjb21taXQgNTcyYzQwYmE5LiAgVGhpcyBpcyBjb21wbGV0ZSBi eSBkZWZpbml0aW9uLCBhbmQgaXQncyBsZXNzIGNvZGUKb3ZlcmFsbC4KCldoaWxlIHdlJ3JlIGF0 IGl0LCB3ZSBjYW4gYWxzbyBleHRlbmQgdGhlIHdhcm5pbmcgTk9USUNFIChvciBFUlJPUgppbiB0 aGUgY2FzZSBvZiBhIG1hdGVyaWFsaXplZCB2aWV3KSB0byBtZW50aW9uIG9uZSBvZiB0aGUgdGVt cApvYmplY3RzIG1vdGl2YXRpbmcgdGhlIGNsYXNzaWZpY2F0aW9uIG9mIHRoZSB2aWV3IGFzIHRl bXAsIGFzIHdhcwpkb25lIGZvciBmdW5jdGlvbnMgaW4gNTcyYzQwYmE5LgoKQXV0aG9yOiBUb20g TGFuZSA8dGdsQHNzcy5wZ2gucGEudXM+ClJldmlld2VkLWJ5OiBKaW0gSm9uZXMgPGppbS5qb25l c0B1bmktbXVlbnN0ZXIuZGU+CkRpc2N1c3Npb246IGh0dHBzOi8vcG9zdGdyLmVzL20vMTljZjZh ZTEtMDRjZC00MjJjLWE3NjAtZDdlNzVmZTZjYmE5QHVuaS1tdWVuc3Rlci5kZQoKQnJhbmNoCi0t LS0tLQptYXN0ZXIKCkRldGFpbHMKLS0tLS0tLQpodHRwczovL2dpdC5wb3N0Z3Jlc3FsLm9yZy9w Zy9jb21taXRkaWZmLzY5OGZhOTI0YjExYTRmZjU1YWM4M2IzNDBkYmFlMWU2Y2VlMDBlNTkKCk1v ZGlmaWVkIEZpbGVzCi0tLS0tLS0tLS0tLS0tCnNyYy9iYWNrZW5kL2NhdGFsb2cvZGVwZW5kZW5j eS5jICAgICAgICAgICB8IDI1ICsrKysrKysrKysrKysrKwpzcmMvYmFja2VuZC9jb21tYW5kcy92 aWV3LmMgICAgICAgICAgICAgICAgfCAgOCArKystLQpzcmMvYmFja2VuZC9wYXJzZXIvYW5hbHl6 ZS5jICAgICAgICAgICAgICAgfCAgOSArKysrLS0Kc3JjL2JhY2tlbmQvcGFyc2VyL3BhcnNlX3Jl bGF0aW9uLmMgICAgICAgIHwgNTEgLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tCnNyYy9p bmNsdWRlL2NhdGFsb2cvZGVwZW5kZW5jeS5oICAgICAgICAgICB8ICAyICsrCnNyYy9pbmNsdWRl L3BhcnNlci9wYXJzZV9yZWxhdGlvbi5oICAgICAgICB8ICAxIC0Kc3JjL3Rlc3QvcmVncmVzcy9l eHBlY3RlZC9jcmVhdGVfdmlldy5vdXQgIHwgMjEgKysrKysrKysrKy0tCnNyYy90ZXN0L3JlZ3Jl c3MvZXhwZWN0ZWQvZ3JvdXBpbmdzZXRzLm91dCB8ICAxICsKc3JjL3Rlc3QvcmVncmVzcy9leHBl Y3RlZC9tYXR2aWV3Lm91dCAgICAgIHwgIDUgKysrCnNyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQv d2luZG93Lm91dCAgICAgICB8ICAxICsKc3JjL3Rlc3QvcmVncmVzcy9zcWwvY3JlYXRlX3ZpZXcu c3FsICAgICAgIHwgIDQgKy0tCnNyYy90ZXN0L3JlZ3Jlc3Mvc3FsL21hdHZpZXcuc3FsICAgICAg ICAgICB8ICA0ICsrKwoxMiBmaWxlcyBjaGFuZ2VkLCA3MSBpbnNlcnRpb25zKCspLCA2MSBkZWxl dGlvbnMoLSkKCg== --===============7928388879846992246==--