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 1uFYcK-005o5L-6w for pgsql-bugs@arkaria.postgresql.org; Thu, 15 May 2025 13:27:20 +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 1uFYcJ-00Ebfw-5B for pgsql-bugs@arkaria.postgresql.org; Thu, 15 May 2025 13:27:19 +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 1uFPqK-00BzL3-N8 for pgsql-bugs@lists.postgresql.org; Thu, 15 May 2025 04:05:12 +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 1uFPqF-001y7z-2P for pgsql-bugs@lists.postgresql.org; Thu, 15 May 2025 04:05:12 +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=zhFiwTFMYw6ZVAZY3liVmpblpDITRTOV0oM9lze9qqw=; b=Njd4d1KhYWztGPoavr9Fpxga1l 7yGTUJS/rPfDbVh0DKmTPvDa/xFwYgkGEZzCDUW0GWiMi5U9niEKIyavsfQXZHK1RTmCWJdjciNaL ymjKFUVP8GMzRNWIrnYKKJrNLHB94G58pzA1eHFF5WrYYQMCyVE7WDT6p5LKntOtMmEFyTK5m9lk5 DOHEiRXoSwBJHmZTF8aZelNkzAQr1ZgreHDDTlxmjJ852D4nL14KBrBDh4StHOT7mu01YSvn+q3eb 3pK9YvUVvvfn9LaPA3ABGNcE++S2FUkZL5qR3HWorUaAQzuk4WlHXEXl6cz3P/8ejlEIFalS1UzhO f3wocZzw==; 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 1uFPqC-005J3x-2u for pgsql-bugs@lists.postgresql.org; Thu, 15 May 2025 04:05:06 +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 1uFPqB-0059Qr-0E for pgsql-bugs@lists.postgresql.org; Thu, 15 May 2025 04:05:03 +0000 Content-Type: multipart/mixed; boundary="===============1659227703328299270==" MIME-Version: 1.0 Subject: BUG #18929: After the view is created, executed query against the view definition, reported syntax error. To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: 707330139@qq.com Reply-To: 707330139@qq.com, pgsql-bugs@lists.postgresql.org Date: Thu, 15 May 2025 04:04:23 +0000 Message-ID: <18929-077d6b7093b176e2@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 --===============1659227703328299270== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODkyOQpMb2dnZWQgYnk6ICAgICAgICAgIHlvbmdoYW8gbGVlCkVtYWls IGFkZHJlc3M6ICAgICAgNzA3MzMwMTM5QHFxLmNvbQpQb3N0Z3JlU1FMIHZlcnNpb246IDE3LjUK T3BlcmF0aW5nIHN5c3RlbTogICBsaW51eApEZXNjcmlwdGlvbjogICAgICAgIAoKSGVsbG8gUG9z dGdyZVNRTCB0ZWFtLApJIGZvdW5kIGFuIGVycm9yIGluIHRoZSB2aWV3IGRlZmluaXRpb24gU1FM IGdpdmVuIHdoZW4gbG9va2luZyBhdCB0aGUgdmlldwpkZXNjcmlwdGlvbiB1c2luZyBcZCsuIEhl cmUgYXJlIHRoZSBkZXRhaWxlZCBzdGVwcyBmb3IgdGhpcyBwcm9ibGVtLgpleGVjdXRlZCBxdWVy eToKcG9zdGdyZXM9IyAgQ1JFQVRFIFRBQkxFIG9uZWsgKHRob3VzYW5kIGludDQpOwpDUkVBVEUg VEFCTEUKcG9zdGdyZXM9IyAgQ1JFQVRFIFZJRVcgbGltaXRfdGhvdXNhbmRfdl8zIEFTIFNFTEVD VCB0aG91c2FuZCBGUk9NIG9uZWsKV0hFUkUgdGhvdXNhbmQgPCA5OTUgIE9SREVSIEJZIHRob3Vz YW5kIEZFVENIIEZJUlNUIChOVUxMOjpiaWdpbnQgKwoxOjpiaWdpbnQpIFJPV1MgV0lUSCBUSUVT OwpDUkVBVEUgVklFVwpwb3N0Z3Jlcz0jICBcZCsgbGltaXRfdGhvdXNhbmRfdl8zCiAgICAgICAg ICAgICAgICAgICAgICBWaWV3ICJwdWJsaWMubGltaXRfdGhvdXNhbmRfdl8zIgogIENvbHVtbiAg fCAgVHlwZSAgIHwgQ29sbGF0aW9uIHwgTnVsbGFibGUgfCBEZWZhdWx0IHwgU3RvcmFnZSB8IERl c2NyaXB0aW9uCi0tLS0tLS0tLS0rLS0tLS0tLS0tKy0tLS0tLS0tLS0tKy0tLS0tLS0tLS0rLS0t LS0tLS0tKy0tLS0tLS0tLSstLS0tLS0tLS0tLS0tCiB0aG91c2FuZCB8IGludGVnZXIgfCAgICAg ICAgICAgfCAgICAgICAgICB8ICAgICAgICAgfCBwbGFpbiAgIHwKVmlldyBkZWZpbml0aW9uOgog U0VMRUNUIHRob3VzYW5kCiAgIEZST00gb25lawogIFdIRVJFIHRob3VzYW5kIDwgOTk1CiAgT1JE RVIgQlkgdGhvdXNhbmQKIEZFVENIIEZJUlNUIE5VTEw6OmJpZ2ludCArIDE6OmJpZ2ludCBST1dT IFdJVEggVElFUzsKcG9zdGdyZXM9IyBTRUxFQ1QgdGhvdXNhbmQKcG9zdGdyZXMtIyAgICBGUk9N IG9uZWsKcG9zdGdyZXMtIyAgIFdIRVJFIHRob3VzYW5kIDwgOTk1CnBvc3RncmVzLSMgICBPUkRF UiBCWSB0aG91c2FuZApwb3N0Z3Jlcy0jICBGRVRDSCBGSVJTVCBOVUxMOjpiaWdpbnQgKyAxOjpi aWdpbnQgUk9XUyBXSVRIIFRJRVM7CkVSUk9SOiAgc3ludGF4IGVycm9yIGF0IG9yIG5lYXIgIjo6 IgpMSU5FIDU6ICBGRVRDSCBGSVJTVCBOVUxMOjpiaWdpbnQgKyAxOjpiaWdpbnQgUk9XUyBXSVRI IFRJRVM7CiAgICAgICAgICAgICAgICAgICAgICAgICBeCkkgdGhpbmsgdGhhdCBleGVjdXRpbmcg dGhlIHZpZXcgZGVmaW5pdGlvbiBxdWVyeSB3aWxsIGJlIHN1Y2Nlc3NmdWwuCkknbSBoYXBweSB0 byBwcm92aWRlIG1vcmUgaW5mbyBpZiBJIGNhbi8gaWYgbmVlZGVkLgpUaGFua3MsCiAgICB5b25n aGFvIGxlZSwKICAgIEhpZ2hnbyBzb2Z0d2FyZS4KCg== --===============1659227703328299270==--