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 1siXny-00606e-9h for pgsql-bugs@arkaria.postgresql.org; Mon, 26 Aug 2024 11:22:38 +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 1siXnw-008ngE-37 for pgsql-bugs@arkaria.postgresql.org; Mon, 26 Aug 2024 11:22:36 +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 1siTRV-005n8k-4m for pgsql-bugs@lists.postgresql.org; Mon, 26 Aug 2024 06:43:09 +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 1siTRS-001TTz-37 for pgsql-bugs@lists.postgresql.org; Mon, 26 Aug 2024 06:43:08 +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=GP31QJiCmc/RrwfqEEzZclweo/xO7jwE/7pIZQNjCZs=; b=ZovHxr3zBd6umGf3NlL6UXcCys gzMlByVToYNNcdoLXt9s+qs7KjNegFeDTYKjWAH0RFBaOd4S35LbnIx9AQyuM5b4vMEyO7H6t3cU5 dAYiO42iCq8zEnGsy69QBnFdzjL4l4AeXyKo4OuIl+ZgHd69P9oQ0q4/w2dpazKf7ISzI95Uug4uP /qTcG5Y/qQlXOvksWh9H5FxsnDkl/ByR7w4YRSwzq9lluYGMn1z/b8XI9brkhnnfK8bdnnyexqjIA UWDjVuhMUIQ6R1FddODgkjxStvdtC2qAW0RNHK3L81w8mdLN/mOtLt84bML2totrpplF9qrTfNehK MtaZUhxA==; Received: from wrigleys.postgresql.org ([2a02:16a8:dc51::60]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1siTRQ-0051aW-UH for pgsql-bugs@lists.postgresql.org; Mon, 26 Aug 2024 06:43:05 +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 1siTRP-0024za-13 for pgsql-bugs@lists.postgresql.org; Mon, 26 Aug 2024 06:43:03 +0000 Content-Type: multipart/mixed; boundary="===============7758469387405483415==" MIME-Version: 1.0 Subject: BUG #18589: pg_get_viewdef returns wrong query To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: tlhquynh@gmail.com Reply-To: tlhquynh@gmail.com, pgsql-bugs@lists.postgresql.org Date: Mon, 26 Aug 2024 06:42:36 +0000 Message-ID: <18589-70091cb81db1a3f1@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 --===============7758469387405483415== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODU4OQpMb2dnZWQgYnk6ICAgICAgICAgIFF1eW5oIFRyYW4KRW1haWwg YWRkcmVzczogICAgICB0bGhxdXluaEBnbWFpbC5jb20KUG9zdGdyZVNRTCB2ZXJzaW9uOiAxNi4z Ck9wZXJhdGluZyBzeXN0ZW06ICAgY2xvdWQuZ29vZ2xlLmNvbS9jb250YWluZXItb3B0aW1pemVk LW9zCkRlc2NyaXB0aW9uOiAgICAgICAgCgpIaSwNCg0KSW4gUG9zdGdyZVNRTCAxNi4zLCBhZnRl ciBJIGNyZWF0ZWQgYSB2aWV3IGJ5IGEgc3RhdGVtZW50IGxpa2UgDQoiY3JlYXRlIHZpZXcga3Z2 aWV3IGFzIHNlbGVjdCBrZXkgYXMgdmFsdWUsIHZhbHVlIGFzIGtleSBmcm9tIGt2IG9yZGVyIGJ5 CnZhbHVlIiwNCkkgcmV0cmlldmVkIGEgZGlmZmVyZW50IGRlZmluaXRpb24gZnJvbSBpbmZvcm1h dGlvbl9zY2hlbWEudmlld3MNCiJTRUxFQ1Qga2V5IEFTIHZhbHVlLCB2YWx1ZSBBUyBrZXkgRlJP TSBrdiBPUkRFUiBCWSBrZXkiLg0KSSBleHBlY3QgT1JERVIgQlkgY29sdW1uIGJlIHZhbHVlLg0K DQpJIHRyaWVkIHRoZSBzYW1lIGluIFBvc3RncmVTUUwgMTQuMTIgYW5kIDE1LjcgYW5kIGdvdCBj b3JyZWN0IGVxdWl2YWxlbnQKZGVmaW5pdGlvbnMuDQoiU0VMRUNUIGtleXZhbHVlLmtleSBBUyB2 YWx1ZSwga2V5dmFsdWUudmFsdWUgQVMga2V5IEZST00ga2V5dmFsdWUgT1JERVIgQlkKa2V5dmFs dWUua2V5Ig0KDQpTbyB0aGlzIHNlZW1zIHRvIGJlIGEgcmVncmVzc2lvbi4NCg0KQmVsb3cgYXJl IHN0ZXBzIHRvIHJlcHJvZHVjZSBpbiBQb3N0Z3JlU1FMIDE2LjM6DQo+IGNyZWF0ZSB0YWJsZSBr diAoa2V5IGludCBwcmltYXJ5IGtleSwgdmFsdWUgdGV4dCk7DQpRdWVyeSBPSywgMCByb3dzIGFm ZmVjdGVkICg1LjI3IHNlYykNCg0KPiBpbnNlcnQgaW50byBrdiB2YWx1ZXMgKDEsICd6JyksICgy LCAneicpLCAoMywgJ3knKTsNClF1ZXJ5IE9LLCAzIHJvd3MgYWZmZWN0ZWQgKDAuNDAgc2VjKQ0K DQo+IHNlbGVjdCBrZXkgYXMgdmFsdWUsIHZhbHVlIGFzIGtleSBmcm9tIGt2IG9yZGVyIGJ5IHZh bHVlOyAgLS0gVGhpcyBpcyB3aGF0CndlIHdhbnQgdG8gc2VlLg0KKy0tLS0tLS0rLS0tLS0rDQp8 IHZhbHVlIHwga2V5IHwNCistLS0tLS0tKy0tLS0tKw0KfCAxICAgICB8IHogICB8DQp8IDIgICAg IHwgeiAgIHwNCnwgMyAgICAgfCB5ICAgfA0KKy0tLS0tLS0rLS0tLS0rDQozIHJvd3MgaW4gc2V0 ICg0LjA0IG1zZWNzKQ0KDQo+IGNyZWF0ZSB2aWV3IGt2dmlldyBhcyBzZWxlY3Qga2V5IGFzIHZh bHVlLCB2YWx1ZSBhcyBrZXkgZnJvbSBrdiBvcmRlciBieQp2YWx1ZTsgIC0tIENyZWF0ZSB2aWV3 IHdpdGggc2FtZSBkZWZpbml0aW9uIGFzIHRoZSBxdWVyeSBhYm92ZS4NClF1ZXJ5IE9LLCAwIHJv d3MgYWZmZWN0ZWQgKDExLjAwIHNlYykNCg0KPiBzZWxlY3QgKiBmcm9tIGt2dmlldzsgIC0tIFZp ZXcgYWxzbyBoYXMgY29ycmVjdCByZXN1bHQuDQorLS0tLS0tLSstLS0tLSsNCnwgdmFsdWUgfCBr ZXkgfA0KKy0tLS0tLS0rLS0tLS0rDQp8IDEgICAgIHwgeiAgIHwNCnwgMiAgICAgfCB6ICAgfA0K fCAzICAgICB8IHkgICB8DQorLS0tLS0tLSstLS0tLSsNCjMgcm93cyBpbiBzZXQgKDQuMDUgbXNl Y3MpDQoNCj4gc2VsZWN0IHRhYmxlX25hbWUsIHZpZXdfZGVmaW5pdGlvbiBmcm9tIGluZm9ybWF0 aW9uX3NjaGVtYS52aWV3czsgIC0tIEJ1dAppbmZvcm1hdGlvbl9zY2hlbWEgZGlzcGxheXMgdGhl IHdyb25nIHZpZXcgZGVmaW5pdGlvbiENCistLS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tKw0KfCB0YWJsZV9uYW1l IHwgdmlld19kZWZpbml0aW9uICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgIAp8DQorLS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLSsNCnwga3Z2aWV3IHwgU0VMRUNUIGtleSBBUyB2YWx1 ZSwgdmFsdWUgQVMga2V5IEZST00ga3YgT1JERVIgQlkga2V5IHwNCistLS0tLS0tLS0tLS0rLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t Kw0KMSByb3dzIGluIHNldCAoMTEuNjcgbXNlY3MpDQoNCj4gc2VsZWN0IGtleSBhcyB2YWx1ZSwg dmFsdWUgYXMga2V5IGZyb20ga3Ygb3JkZXIgYnkga2V5OyAgLS0gVGhlIHZpZXcKZGVmaW5pdGlv biB3b3VsZCBnaXZlIHRoZSB3cm9uZyByZXN1bHQgaWYgdGhhdCB3ZXJlIHdoYXQgd2FzIGFjdHVh bGx5CmV4ZWN1dGVkLg0KKy0tLS0tLS0rLS0tLS0rDQp8IHZhbHVlIHwga2V5IHwNCistLS0tLS0t Ky0tLS0tKw0KfCAzICAgICB8IHkgICB8DQp8IDEgICAgIHwgeiAgIHwNCnwgMiAgICAgfCB6ICAg fA0KKy0tLS0tLS0rLS0tLS0rDQozIHJvd3MgaW4gc2V0ICgxNi43NiBtc2VjcykKCg== --===============7758469387405483415==--