Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oiG4T-00044U-66 for pgsql-bugs@arkaria.postgresql.org; Tue, 11 Oct 2022 14:17:25 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oiG4R-00006O-0P for pgsql-bugs@arkaria.postgresql.org; Tue, 11 Oct 2022 14:17:23 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oiFNc-0003jP-81 for pgsql-bugs@lists.postgresql.org; Tue, 11 Oct 2022 13:33:08 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oiFNZ-0001Zh-Vs for pgsql-bugs@lists.postgresql.org; Tue, 11 Oct 2022 13:33:07 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:Cc:From:To:Subject: MIME-Version:Content-Type:Sender:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=7YW5R2pOC0JS8cgKZhQw2/bBFs4INOwN5gu2RfNMzy0=; b=VN6Tw7Ce2IGuh8jNxYTSFFiR2B AYE8feWJgzYyNeVeyk/qQuXUYP01GxWGTlRbaQs4lJVLSMgqRGTYJWlncOeLhVL3QPdmZAAJ5e/Z7 are1WU8BdEx2rAlKhEOzKStPbA48Cgt1VGvAzehdgbFth4t/4m26nvYJRAtm6k0aTd6YYQAwE+FyI jXk+OYyvS7cl+L8Yh/bc9nlSDY/AZ0cb2zbHmPOUN1cOidaVDz/KxydusSYgNMnyyGP+1tczXvZ5d rDe8IJNQQ2CP4GuuNJNASy3fHD0WZu6nhAklo5eA53buTU9T43Gy4FzfFbL3gRZUKMy/RKrdtgR9S /N+bXU7Q==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oiFNY-00036J-F8 for pgsql-bugs@lists.postgresql.org; Tue, 11 Oct 2022 13:33:04 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1oiFNW-004wPK-Ec for pgsql-bugs@lists.postgresql.org; Tue, 11 Oct 2022 13:33:02 +0000 Content-Type: multipart/mixed; boundary="===============2561362079682897276==" MIME-Version: 1.0 Subject: BUG #17634: Inconsistent view_definition in information_schema.views To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: kimber7@illinois.edu Reply-To: kimber7@illinois.edu, pgsql-bugs@lists.postgresql.org Date: Tue, 11 Oct 2022 13:32:03 +0000 Message-ID: <17634-fd5cb524a79c1df9@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============2561362079682897276== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzYzNApMb2dnZWQgYnk6ICAgICAgICAgIEtpbWJlcmx5IEJsdW0KRW1h aWwgYWRkcmVzczogICAgICBraW1iZXI3QGlsbGlub2lzLmVkdQpQb3N0Z3JlU1FMIHZlcnNpb246 IDE0LjUKT3BlcmF0aW5nIHN5c3RlbTogICBSSEVMIDgKRGVzY3JpcHRpb246ICAgICAgICAKCkkg dXNlIGluZm9ybWF0aW9uX3NjaGVtYS52aWV3cyAodGhlIHZpZXdfZGVmaW5pdGlvbiBjb2x1bW4p IGluIGNvZGUgdGhhdApwcm92aWRlcyBkZXBlbmRlbmN5IGluZm9ybWF0aW9uIGZvciBmdW5jdGlv bnMgYW5kIHByb2NlZHVyZXMuIEFsbCBvYmplY3RzIGluCm15IGNvZGUgYXJlIHNjaGVtYSBxdWFs aWZpZWQsIGFuZCB3aGVuIEkgbG9vayBmb3IgZGVwZW5kZW5jaWVzLCBJIHJlbHkgb24KdGhhdCBx dWFsaWZpY2F0aW9uLiANCg0KSWYgSSBydW4gbXkgcXVlcnkgYWdhaW5zdCBpbmZvcm1hdGlvbl9z Y2hlbWEudmlld3Mgd2hpbGUgbXkgc2Vzc2lvbiBpcwphY3RpdmUgaW4gYSBzY2hlbWEgdGhhdCBp cyByZWZlcmVuY2VkIGluIG15IHF1ZXJ5LCBpbmZvcm1hdGlvbl9zY2hlbWEudmlld3MKc3RyaXBz IG91dCB0aGF0IHNjaGVtYSBuYW1lLiBBbGwgb3RoZXIgb2JqZWN0cyByZW1haW4gc2NoZW1hIHF1 YWxpZmllZC4NCg0KTXkgZXhhbXBsZSBxdWVyeTogDQpTRUxFQ1Qgdmlld19kZWZpbml0aW9uIEZS T00gaW5mb3JtYXRpb25fc2NoZW1hLnZpZXdzIFdIRVJFIHRhYmxlX3NjaGVtYSA9CidhcHBjb2Rl JyBBTkQgdGFibGVfbmFtZSA9ICdjZmdfbXNnX3YnOw0KDQpUaGUgcmVzdWx0cyBmcm9tIGZpcnN0 IHF1ZXJ5LCB3aGljaCB3YXMgcnVuIGZyb20gc2NoZW1hIGFwaSAod2hpY2ggaXMgbm90CnJlZmVy ZW5jZWQgaW4gdGhlIGNvZGUpLCBhbmQgYWxsIHNjaGVtYSBxdWFsaWZpY2F0aW9uIHNob3dzIHVw LiBOb3RlIGFsbCB0aGUKYXJlYXMgd2hlcmUgYXBwY2ZnLjxvYmo+IGlzIHNob3duLg0KcXVlcnk6 IHNlbGVjdCB2aWV3X2RlZmluaXRpb24gZnJvbSBpbmZvcm1hdGlvbl9zY2hlbWEudmlld3Mgd2hl cmUgDQogU0VMRUNUIGNmZ19tc2cuaWRfbXNnLA0KICAgIGNmZ19tc2cuaWRfc3JjLA0KICAgIGNm Z19zcmMuc3JjX25hbWUsDQogICAgY2ZnX21zZy5tc2dfdHlwZSwNCiAgICBjZmdfbXNnLm1zZ192 ZXJzaW9uLA0KICAgIGNmZ19tc2cuaWRfY2xhc3MsDQogICAgY2ZnX2NscyBjbGFzc19uYW1lLA0K ICAgIGNmZ19tc2cuZGVzY3JpcHQNCiAgIEZST00gKChhcHBjZmcuY2ZnX21zZyBjZmdfbXNnDQog ICAgIEpPSU4gYXBwY2ZnLmNmZ19kYXRhX3NyYyBjZmdfc3JjIE9OICgoKGNmZ19tc2cuaWRfc3Jj KTo6aW50ZWdlciA9CihjZmdfc3JjLmlkX3NyYyk6OmludGVnZXIpKSkNCiAgICAgSk9JTiBjbWRi LmNmZ19jbGFzcyBjZmdfY2xzIE9OICgoKGNmZ19tc2cuaWRfY2xhc3MpOjppbnRlZ2VyID0KKGNm Z19jbHMuaWRfY2xhc3MpOjppbnRlZ2VyKSkpOw0KDQpJZiBJIHN3aXRjaCBteSBzZXNzaW9uIHRv IHRoZSBhcHBjZmcgc2NoZW1hLCBhbmQgcnVuIHRoZSBzYW1lIHF1ZXJ5LCB0aGlzIGlzCnRoZSBy ZXN1bHQgKGFwcGNmZyBxdWFsaWZpY2F0aW9uIGRpc2FwcGVhcnMsIG90aGVyIHNjaGVtYSBxdWFs aWZpY2F0aW9uIGlzCmZpbmUpLiANCiBTRUxFQ1QgY2ZnX21zZy5pZF9tc2csDQogICAgY2ZnX21z Zy5pZF9zcmMsDQogICAgY2ZnX3NyYy5zcmNfbmFtZSwNCiAgICBjZmdfbXNnLm1zZ190eXBlLA0K ICAgIGNmZ19tc2cubXNnX3ZlcnNpb24sDQogICAgY2ZnX21zZy5pZF9jbGFzcywNCiAgICBjZmdf Y2xzLmNsYXNzX25hbWUsDQogICAgY2ZnX21zZy5kZXNjcmlwdA0KICAgRlJPTSAoKGNmZ19tc2cg Y2ZnX21zZw0KICAgICBKT0lOIGNmZ19kYXRhX3NyYyBjZmdfc3JjIE9OICgoKGNmZ19tc2cuaWRf c3JjKTo6aW50ZWdlciA9CihjZmdfc3JjLmlkX3NyYyk6OmludGVnZXIpKSkNCiAgICAgSk9JTiBj bWRiLmNmZ19jbGFzcyBjZmdfY2xzIE9OICgoKGNmZ19tc2cuaWRfY2xhc3MpOjppbnRlZ2VyID0K KGNmZ19jbHMuaWRfY2xhc3MpOjppbnRlZ2VyKSkpOwoK --===============2561362079682897276==--