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 1klEjd-0005IO-6D for pgsql-bugs@arkaria.postgresql.org; Fri, 04 Dec 2020 17:19:09 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1klEjc-0001RC-3l for pgsql-bugs@arkaria.postgresql.org; Fri, 04 Dec 2020 17:19:08 +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 1klEZu-0007AL-QO for pgsql-bugs@lists.postgresql.org; Fri, 04 Dec 2020 17:09:06 +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 1klEZs-0003pR-S6 for pgsql-bugs@lists.postgresql.org; Fri, 04 Dec 2020 17:09:06 +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=d+OohXJ6OkrWfe+SduO+ahdvDIHXZlkZn0ofOpqkPsA=; b=sGx+NVRaLIpZJlNa3dCix3kSRg ymNlsi4A0L3eR14I3XG1gadZYGEhDvb/rFVj9L35Uek/YqndmWDQgVzJiG7yXKjnlo13s+8IqoN7J ZFHrR/nT/bIg02qgY9NhOEZk1aDCtBjjnNOYqFT3gxu5P3EnnkwPw4uaRzUQ/MyNeAN3ezq7PqAUF rDEIe5MI1foyhWHMPfyQcVr0z/stbR3o5IyER5LeKxs18DFGihUDrjgtdOO/dz1SpQCeiAQcosMau qH/iS4z127uo+Ig05k8tpoesQIw7uIRFbCYmk4evJqswK3DJTB4QSHlBcnNyt5kZ4pu9ZimNI+qk+ kUCR8fZw==; 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 1klEZr-0007yR-F7 for pgsql-bugs@lists.postgresql.org; Fri, 04 Dec 2020 17:09:03 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1klEZq-0007YH-8l for pgsql-bugs@lists.postgresql.org; Fri, 04 Dec 2020 17:09:02 +0000 Content-Type: multipart/mixed; boundary="===============4635738878263265138==" MIME-Version: 1.0 Subject: BUG #16763: CREATE TABLE IF NOT EXISTS fails with "relation exists" To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: gatekeeper.mail@gmail.com Reply-To: gatekeeper.mail@gmail.com, pgsql-bugs@lists.postgresql.org Date: Fri, 04 Dec 2020 17:08:29 +0000 Message-ID: <16763-a1c5f839345c4e80@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============4635738878263265138== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjc2MwpMb2dnZWQgYnk6ICAgICAgICAgIEFuZHkgUwpFbWFpbCBhZGRy ZXNzOiAgICAgIGdhdGVrZWVwZXIubWFpbEBnbWFpbC5jb20KUG9zdGdyZVNRTCB2ZXJzaW9uOiAx MS4yCk9wZXJhdGluZyBzeXN0ZW06ICAgTGludXgKRGVzY3JpcHRpb246ICAgICAgICAKCk91ciBh cHBsaWNhdGlvbiBpcyBydW4gd2l0aCBhIG51bWJlciBvZiBzaW11bHRhbmVvdXMgaW5zdGFuY2Vz IGVhY2ggb2YgdGhlbQplbWl0cyBib3RoIERETCBhbmQgRE1MIHRvIHRoZSBEQi4NCg0KRm9yIGV4 YW1wbGUsIGF0IHRoZSB2ZXJ5IHN0YXJ0IHRoZXkgZW5zdXJlIGJhc2UgdGFibGUgc3RydWN0dXJl IGV4aXN0cyBzbwp0aGUgZW1pdCBxdWVyaWVzIGxpa2U6DQoNCkNSRUFURSBUQUJMRSBJRiBOT1Qg RVhJU1RTIHRibG5hbWUgKC4uLik7DQoNCkR1cmluZyBydW50aW1lIHRoZXkgYWxzbyBlbWl0IHF1 ZXJpZXMgdG8gY3JlYXRlIG5ldyBwYXJ0aXRpb25zIHRvIGV4aXN0aW5nCnBhcnRpdGlvbmVkIHRh Ymxlcy4gU2luY2UgYm90aCBzdGFydHVwIGFuZC9vciBydW50aW1lIERETCBjb3VsZCBiZSBlbWl0 ZWQKc2ltdWx0YW5lb3VzbHkgdGhleSBzdWRkZW5seSBhcmUuIFRoaXMgbGVhZHMgdG8gZXJyb3Jz IGxpa2UgdGhpczoNCg0KMjAyMC0xMi0wNCAxNjozODo0NS43ODUgR01UIFsxODgxNF0gRVJST1I6 ICByZWxhdGlvbgoidGJsbmFtZV9zaG9ydF82MF8yNjU3XzMiIGFscmVhZHkgZXhpc3RzDQoyMDIw LTEyLTA0IDE2OjM4OjQ1Ljc4NSBHTVQgWzE4ODE0XSBTVEFURU1FTlQ6ICBDUkVBVEUgVEFCTEUg SUYgTk9UIEVYSVNUUwp0YmxuYW1lX3Nob3J0XzYwXzI2NTdfMyBQQVJUSVRJT04gT0YgdGJsbmFt ZV9zaG9ydF82MF8yNjU3IEZPUiBWQUxVRVMgV0lUSAooTU9EVUxVUyAxMCwgUkVNQUlOREVSIDMp DQoyMDIwLTEyLTA0IDE2OjM4OjQ1Ljc4NiBHTVQgWzE4ODQ5XSBFUlJPUjogIHJlbGF0aW9uCiJ0 YmxuYW1lX3Nob3J0XzYwXzI2NTdfMyIgYWxyZWFkeSBleGlzdHMNCjIwMjAtMTItMDQgMTY6Mzg6 NDUuNzg2IEdNVCBbMTg4NDldIFNUQVRFTUVOVDogIENSRUFURSBUQUJMRSBJRiBOT1QgRVhJU1RT CnRibG5hbWVfc2hvcnRfNjBfMjY1N18zIFBBUlRJVElPTiBPRiB0YmxuYW1lX3Nob3J0XzYwXzI2 NTcgRk9SIFZBTFVFUyBXSVRICihNT0RVTFVTIDEwLCBSRU1BSU5ERVIgMykNCjIwMjAtMTItMDQg MTY6Mzg6NDcuMzA2IEdNVCBbMTg4NjhdIEVSUk9SOiAgcmVsYXRpb24KInRibG5hbWVfc2hvcnRf NjBfMjY1N181IiBhbHJlYWR5IGV4aXN0cw0KMjAyMC0xMi0wNCAxNjozODo0Ny4zMDYgR01UIFsx ODg2OF0gU1RBVEVNRU5UOiAgQ1JFQVRFIFRBQkxFIElGIE5PVCBFWElTVFMKdGJsbmFtZV9zaG9y dF82MF8yNjU3XzUgUEFSVElUSU9OIE9GIHRibG5hbWVfc2hvcnRfNjBfMjY1NyBGT1IgVkFMVUVT IFdJVEgKKE1PRFVMVVMgMTAsIFJFTUFJTkRFUiA1KQ0KMjAyMC0xMi0wNCAxNjozODo1MC4xMTgg R01UIFsxODgyMV0gRVJST1I6ICByZWxhdGlvbgoidGJsbmFtZV9tZWRpdW1fMTgwXzYyMF8wIiBh bHJlYWR5IGV4aXN0cw0KMjAyMC0xMi0wNCAxNjozODo1MC4xMTggR01UIFsxODgyMV0gU1RBVEVN RU5UOiAgQ1JFQVRFIFRBQkxFIElGIE5PVCBFWElTVFMKdGJsbmFtZV9tZWRpdW1fMTgwXzYyMF8w IFBBUlRJVElPTiBPRiB0YmxuYW1lX21lZGl1bV8xODBfNjIwIEZPUiBWQUxVRVMgV0lUSAooTU9E VUxVUyAxMCwgUkVNQUlOREVSIDApDQoyMDIwLTEyLTA0IDE2OjM4OjUyLjI0NyBHTVQgWzE1MDIx XSBFUlJPUjogIHJlbGF0aW9uCiJ0YmxuYW1lX21lZGl1bV8xODBfNjIwXzQiIGFscmVhZHkgZXhp c3RzDQoyMDIwLTEyLTA0IDE2OjM4OjUyLjI0NyBHTVQgWzE1MDIxXSBTVEFURU1FTlQ6ICBDUkVB VEUgVEFCTEUgSUYgTk9UIEVYSVNUUwp0YmxuYW1lX21lZGl1bV8xODBfNjIwXzQgUEFSVElUSU9O IE9GIHRibG5hbWVfbWVkaXVtXzE4MF82MjAgRk9SIFZBTFVFUyBXSVRICihNT0RVTFVTIDEwLCBS RU1BSU5ERVIgNCkNCjIwMjAtMTItMDQgMTY6Mzg6NTIuNzE5IEdNVCBbMTQ5NThdIEVSUk9SOiAg cmVsYXRpb24KInRibG5hbWVfbWVkaXVtXzE4MF82MjBfNSIgYWxyZWFkeSBleGlzdHMNCjIwMjAt MTItMDQgMTY6Mzg6NTIuNzE5IEdNVCBbMTQ5NThdIFNUQVRFTUVOVDogIENSRUFURSBUQUJMRSBJ RiBOT1QgRVhJU1RTCnRibG5hbWVfbWVkaXVtXzE4MF82MjBfNSBQQVJUSVRJT04gT0YgdGJsbmFt ZV9tZWRpdW1fMTgwXzYyMCBGT1IgVkFMVUVTIFdJVEgKKE1PRFVMVVMgMTAsIFJFTUFJTkRFUiA1 KQ0KDQoNClRoZSBzYW1lIHByb2JsZW0gcGVyc2lzdHMgYXQgbGVhc3QgYXQgUG9zdGdyZVNRTCAx Mi4yLiBUaGUgc2VydmVyIHNob3VsZCBub3QKcmFpc2UgZXhjZXB0aW9uIGxldmVsIGVycm9yIG9u IGBDUkVBVEUgPyBJRiBOT1QgRVhJU1RTYCBxdWVyaWVzLg0KSGVyZSdzIHRoZSBkb2MgKHZlcnNp b24gMTEpOg0KDQpJRiBOT1QgRVhJU1RTDQpEbyBub3QgdGhyb3cgYW4gZXJyb3IgaWYgYSByZWxh dGlvbiB3aXRoIHRoZSBzYW1lIG5hbWUgYWxyZWFkeSBleGlzdHMuIEEKbm90aWNlIGlzIGlzc3Vl ZCBpbiB0aGlzIGNhc2UuIE5vdGUgdGhhdCB0aGVyZSBpcyBubyBndWFyYW50ZWUgdGhhdCB0aGUK ZXhpc3RpbmcgcmVsYXRpb24gaXMgYW55dGhpbmcgbGlrZSB0aGUgb25lIHRoYXQgd291bGQgaGF2 ZSBiZWVuIGNyZWF0ZWQuCgo= --===============4635738878263265138==--