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 1u3g58-001XQ7-Rl for pgsql-bugs@arkaria.postgresql.org; Sat, 12 Apr 2025 18:59:59 +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 1u3g57-007w8V-6d for pgsql-bugs@arkaria.postgresql.org; Sat, 12 Apr 2025 18:59:57 +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 1u3Qi4-00HTxh-7n for pgsql-bugs@lists.postgresql.org; Sat, 12 Apr 2025 02:35:08 +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 1u3Qi2-004qhI-16 for pgsql-bugs@lists.postgresql.org; Sat, 12 Apr 2025 02:35: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=7rPCzeZm4ugOCLPoulIT4uv5VEeAXri4+JQHLhq4Ex0=; b=dOYHHqQF4ZYhocduOP7qPYml3H XRPmNS4X+kZIP6x0pkgdQaoINuw631iSibySOgd4VqmVM8yfHy4ET7Jsf+vijiK/Z6B41CV+yEUZK erDKOuveHQY8zw0A/LB68KUbyk/gKRVnlvwLi1F0cubBuOy/7Zv7ShkydBk/5U2FD2bHCMKgcbehR NxrtAdwo854J0I/Ve3SPy96bb0P8Ley3PmqfxwA70HrJX/a/1W6ROEgbwShENqmRr4SCJnmY3dA+a pJsa8f4SfIeGeoDps3ppArVsu6qtCPIzxmKIyWVKZDmqY8ZhxyUZIDlcXlfpt3WGJtk0LQZ5UYQCZ YoXhn5YQ==; 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 1u3Qi0-003lOF-PO for pgsql-bugs@lists.postgresql.org; Sat, 12 Apr 2025 02:35: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 1u3Qhz-006PTz-2d for pgsql-bugs@lists.postgresql.org; Sat, 12 Apr 2025 02:35:02 +0000 Content-Type: multipart/mixed; boundary="===============0548373053522037374==" MIME-Version: 1.0 Subject: BUG #18892: When the view already exists, CREATE OR REPLACE VIEW does not check whether the table exists. To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: gchen@s2now.com Reply-To: gchen@s2now.com, pgsql-bugs@lists.postgresql.org Date: Sat, 12 Apr 2025 02:34:15 +0000 Message-ID: <18892-dc187cc800710924@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 --===============0548373053522037374== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODg5MgpMb2dnZWQgYnk6ICAgICAgICAgIEdhdmluCkVtYWlsIGFkZHJl c3M6ICAgICAgZ2NoZW5AczJub3cuY29tClBvc3RncmVTUUwgdmVyc2lvbjogMTYuOApPcGVyYXRp bmcgc3lzdGVtOiAgIFJlZCBIYXQgRW50ZXJwcmlzZSBMaW51eCByZWxlYXNlIDkuNQpEZXNjcmlw dGlvbjogICAgICAgIAoKVGhlIFNRTCBmb3IgdGVzdGluZyB0aGUgZGVtbyBpcyBhcyBmb2xsb3dz Og0KcG9zdGdyZXM9IyBjcmVhdGUgZGF0YWJhc2UgdGVzdDE7DQpDUkVBVEUgREFUQUJBU0UNCnBv c3RncmVzPSMgXGMgdGVzdDENCllvdSBhcmUgbm93IGNvbm5lY3RlZCB0byBkYXRhYmFzZSAidGVz dDEiIGFzIHVzZXIgInBvc3RncmVzIi4NCnRlc3QxPSMgY3JlYXRlIHNjaGVtYSB0ZXN0Ow0KQ1JF QVRFIFNDSEVNQQ0KdGVzdDE9IyBjcmVhdGUgdGFibGUgdGVzdC50MSAoaWQgaW50KTsNCkNSRUFU RSBUQUJMRQ0KdGVzdDE9IyBjcmVhdGUgdmlldyB0MSBhcyBzZWxlY3QgKiBmcm9tIHQxOw0KRVJS T1I6ICByZWxhdGlvbiAidDEiIGRvZXMgbm90IGV4aXN0DQpMSU5FIDE6IGNyZWF0ZSB2aWV3IHQx IGFzIHNlbGVjdCAqIGZyb20gdDE7DQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgXg0KdGVzdDE9IyBjcmVhdGUgdmlldyB0MSBhcyBzZWxlY3QgKiBmcm9tIHRlc3QudDE7 DQpDUkVBVEUgVklFVw0KdGVzdDE9IyBjcmVhdGUgb3IgcmVwbGFjZSB2aWV3IHQxIGFzIHNlbGVj dCAqIGZyb20gdDE7DQpDUkVBVEUgVklFVw0KdGVzdDE9IyBcZA0KICAgICAgICBMaXN0IG9mIHJl bGF0aW9ucw0KIFNjaGVtYSB8IE5hbWUgfCBUeXBlIHwgIE93bmVyDQotLS0tLS0tLSstLS0tLS0r LS0tLS0tKy0tLS0tLS0tLS0NCiBwdWJsaWMgfCB0MSAgIHwgdmlldyB8IHBvc3RncmVzDQooMSBy b3cpDQoNCldlIGtub3cgdGhhdCBpbiBQb3N0Z3JlU1FMIChQRyksIGl0IGlzIG5vdCBhbGxvd2Vk IHRvIGNyZWF0ZSB0YWJsZXMgYW5kCnZpZXdzIHdpdGggdGhlIHNhbWUgbmFtZSB1bmRlciB0aGUg c2FtZSBzY2hlbWEgaW4gdGhlIGRhdGFiYXNlLiBXaGVuCmNyZWF0aW5nIGEgdmlldyBmb3IgdGhl IGZpcnN0IHRpbWUgKHdoZW4gdGhlIHZpZXcgZG9lcyBub3QgZXhpc3QpLCBpZiB0aGUKdGFibGUg ZG9lcyBub3QgZXhpc3Qgb3IgaGFzIHRoZSBzYW1lIG5hbWUgYXMgdGhlIHZpZXcsIHRoZSBkYXRh YmFzZSB3aWxsCnRocm93IGFuIGVycm9yIGFzIGV4cGVjdGVkLiBIb3dldmVyLCBhcyBkZW1vbnN0 cmF0ZWQgaW4gbXkgdGVzdCBkZW1vLCB3aGVuCnRoZSB2aWV3IGFscmVhZHkgZXhpc3RzLCBydW5u aW5nIENSRUFURSBPUiBSRVBMQUNFIFZJRVcgZG9lcyBub3QgY2hlY2sKd2hldGhlciB0aGUgdGFi bGUgZXhpc3RzLiBBbHRob3VnaCBJIHVuZGVyc3RhbmQgdGhhdCB0aGlzIG1pZ2h0IGJlIGFuIGlz c3VlCndpdGggb3BlcmF0aW9uYWwgcHJhY3RpY2VzLCBhcyBldmVyeW9uZSBrbm93cywgaW4gYSBw cm9kdWN0aW9uIGVudmlyb25tZW50LApvdXIgYXBwbGljYXRpb24gZGV2ZWxvcG1lbnQgdGVhbSBt aWdodCB1bmludGVudGlvbmFsbHkgb3IgaW5hZHZlcnRlbnRseQpjYXVzZSB0aGUgc2FtZSBwcm9i bGVtLiBUaGUgZGVzaWduIG1pZ2h0IGhhdmUgYmVlbiBpbnRlbmRlZCBmb3IgcXVpY2sKcmVzcG9u c2Ugd2l0aG91dCBjaGVja2luZyBpZiB0aGUgdGFibGUgZXhpc3RzLCBidXQgcmF0aGVyIG1vZGlm eWluZyB0aGUKc3lzdGVtIHRhYmxlIChteSBndWVzcykuIElmIHN1Y2ggYW4gaXNzdWUgZXhpc3Rz LCBzaG91bGQgaXQgYmUgY29uc2lkZXJlZCBhCmJ1Z++8nwoK --===============0548373053522037374==--