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 1s1t4V-00FiXA-Ca for pgsql-committers@arkaria.postgresql.org; Tue, 30 Apr 2024 19:23:23 +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 1s1t4T-008CjQ-0C for pgsql-committers@arkaria.postgresql.org; Tue, 30 Apr 2024 19:23:21 +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 1s1t4J-008B11-Ns for pgsql-committers@lists.postgresql.org; Tue, 30 Apr 2024 19:23:12 +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.94.2) (envelope-from ) id 1s1t4F-000oos-DP for pgsql-committers@lists.postgresql.org; Tue, 30 Apr 2024 19:23: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 1s1t4E-002ckR-32 for pgsql-committers@lists.postgresql.org; Tue, 30 Apr 2024 19:23:06 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1s1t4D-000pqV-0E for pgsql-committers@lists.postgresql.org; Tue, 30 Apr 2024 19:23:06 +0000 Content-Type: multipart/mixed; boundary="===============7971476811547260619==" MIME-Version: 1.0 From: Tom Lane To: pgsql-committers@lists.postgresql.org Subject: pgsql: Disallow converting a table to a view within an outer SQL comman X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Tue, 30 Apr 2024 19:23:06 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============7971476811547260619== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 RGlzYWxsb3cgY29udmVydGluZyBhIHRhYmxlIHRvIGEgdmlldyB3aXRoaW4gYW4gb3V0ZXIgU1FM IGNvbW1hbmQuCgpXZSBoYXZlIGxvbmcgZGlzYWxsb3dlZCBhbGwgZm9ybXMgb2YgQUxURVIgVEFC TEUgaWYgdGhlIHRhYmxlIGlzCmFscmVhZHkgb3BlbmVkIGJ5IHNvbWUgb3V0ZXIgU1FMIGNvbW1h bmQgaW4gdGhlIHNhbWUgc2Vzc2lvbi4KVGhpcyBoYXMgdGhlIHNhbWUgcHVycG9zZSBhcyBvYnRh aW5pbmcgQWNjZXNzRXhjbHVzaXZlTG9jaywgYnV0CnNpbmNlIGEgc2Vzc2lvbidzIG93biBsb2Nr cyBkb24ndCBjb25mbGljdCB0aGUgbG9jayBvbmx5IGJsb2NrcyB1c2UKb2YgdGhlIHRhYmxlIGJ5 IG90aGVyIHNlc3Npb25zLCBub3Qgb3VyIG93bi4gIFdpdGhvdXQgdGhpcyBjaGVjaywKdGhlIEFM VEVSIG1pZ2h0IGNvbmZ1c2UgdGhlIG91dGVyIFNRTCBjb21tYW5kIHNpbmNlIGFueSBwcmV2aW91 cwppbnNwZWN0aW9uIG9mIHRoZSB0YWJsZSB3b3VsZCBwb3RlbnRpYWxseSBiZWNvbWUgaW52YWxp ZC4KCkhvd2V2ZXIsIHRoZSBSZWxpc0JlY29taW5nVmlldyBjb2RlIHBhdGggaW4gRGVmaW5lUXVl cnlSZXdyaXRlIG5ldmVyCmdvdCB0aGF0IG1lbW8sIGFuZCBhc3N1bWVkIHRoYXQgQWNjZXNzRXhj bHVzaXZlTG9jayBpcyBzdWZmaWNpZW50CmZvciBwZXJmb3JtaW5nIHNvbWV0aGluZyBtb3JhbGx5 IGVxdWl2YWxlbnQgdG8gYSByYXRoZXIgaW52YXNpdmUKQUxURVIgVEFCTEUuICBVbnN1cnByaXNp bmdseSwgdGhpcyBjYW4gY29uZnVzZSBhbiBvdXRlciBjb21tYW5kCnRoYXQgaXMgdHJ5aW5nIHRv IGRvIHNvbWV0aGluZyB3aXRoIHRoZSB0YWJsZS4KClRoaXMgd2FzIHN1Ym1pdHRlZCBhcyBhIHNl Y3VyaXR5IGlzc3VlLCBidXQgdGhlIHNlY3VyaXR5IHRlYW0KaGFzIGJlZW4gdW5hYmxlIHRvIGlk ZW50aWZ5IGFueSBjb25zZXF1ZW5jZSB3b3JzZSB0aGFuIGEgbnVsbApwb2ludGVyIGRlcmVmZXJl bmNlIChmcm9tIHRyeWluZyB0byBhY2Nlc3MgcmRfdGFibGVhbSBtZXRob2RzCnRoYXQgdGhlIHJl bGF0aW9uIG5vIGxvbmdlciBoYXMpLiAgVGhlcmVmb3JlLCBpbiBhY2NvcmRhbmNlCndpdGggb3Vy IHVzdWFsIHBvbGljeSwgaXQncyBub3Qgc2VjdXJpdHkgbWF0ZXJpYWwgYW5kIHNob3VsZApqdXN0 IGJlIGZpeGVkIGFzIGEgcm91dGluZSBidWcuCgpGaXggYnkgZGlzYWxsb3dpbmcgdGhlIG9wZXJh dGlvbiBpZiB0aGUgdGFibGUgaXMgb3BlbiBsb2NhbGx5LApleGFjdGx5IGFzIEFMVEVSIFRBQkxF IGRvZXMgaXQuCgpQZXIgYW4gYW5vbnltb3VzIHNlY3VyaXR5IHJlc2VhcmNoZXIsIHZpYSBCdW5k ZXNhbXQgZsO8ciBTaWNoZXJoZWl0CmluIGRlciBJbmZvcm1hdGlvbnN0ZWNobmlrLgoKUGF0Y2gg djEyLXYxNSBvbmx5LiAgSW4gdjE2IGFuZCBsYXRlciwgd2UgcmVtb3ZlZCB0aGlzIGNvZGUKYWx0 b2dldGhlciAoY2YuIGNvbW1pdCBiMjNjZDE4NWYpLCBzbyB0aGF0IHRoZXJlJ3Mgbm8gaXNzdWUu CgpCcmFuY2gKLS0tLS0tClJFTF8xNF9TVEFCTEUKCkRldGFpbHMKLS0tLS0tLQpodHRwczovL2dp dC5wb3N0Z3Jlc3FsLm9yZy9wZy9jb21taXRkaWZmLzUxMTg5Zjk4YTlmYzg4YTYzYWU2YTk2MzVk YThhZGI0MjdmOTk1OGMKCk1vZGlmaWVkIEZpbGVzCi0tLS0tLS0tLS0tLS0tCnNyYy9iYWNrZW5k L3Jld3JpdGUvcmV3cml0ZURlZmluZS5jIHwgNiArKysrKysKMSBmaWxlIGNoYW5nZWQsIDYgaW5z ZXJ0aW9ucygrKQoK --===============7971476811547260619==--