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 1kMC5s-0002iV-Sw for pgsql-bugs@arkaria.postgresql.org; Sat, 26 Sep 2020 15:26:36 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kMC5r-0007wE-R6 for pgsql-bugs@arkaria.postgresql.org; Sat, 26 Sep 2020 15:26:35 +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 1kMBzc-0001CD-Aj for pgsql-bugs@lists.postgresql.org; Sat, 26 Sep 2020 15:20: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 1kMBzZ-00053f-L6 for pgsql-bugs@lists.postgresql.org; Sat, 26 Sep 2020 15:20: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=zFmU4jadmPTNpre6izCqt8a/+LxbmaWUDI2e/9bVULI=; b=MBsm8/sZ5+rvEQaJ6bh3l0jDTG vWkRLr+GSQDdZah+Li+50plOuay+Bs4LKC0kJXOReda7ZtDkRM0PHdJvK7OPy+UcFT62Y7tFEEVWX rq4oUuRixfs89skinE+VCVsjkoJ38KOwi/nQC1jq8O7KElZfKVbEznF85yIHcOKSOr+PnAOeE3uB0 WY8VxxLcEtzENuZm6uIHEBSMV4qUVHc2+nF+c8ppD/6VKUSzwdKyK/lDE3JWP1m6CVXdRYa+oGODE MEVCb4D0w4xs/D+Bd3kEvOvzaj9FS5jtihJxdXewWnHuzyKisz0lOScvXdP/NgDiyOf3rjbnrVLQz MME9z3XQ==; Received: from wrigleys.postgresql.org ([87.238.57.234]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kMBzX-0007zX-Tb for pgsql-bugs@lists.postgresql.org; Sat, 26 Sep 2020 15:20:04 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kMBzW-0006PB-Kj for pgsql-bugs@lists.postgresql.org; Sat, 26 Sep 2020 15:20:02 +0000 Content-Type: multipart/mixed; boundary="===============6024745790621001904==" MIME-Version: 1.0 Subject: BUG #16637: Postgressql throws exception 'relation already exists' when trying to execute partition from code To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: kulluadhikari@gmail.com Reply-To: kulluadhikari@gmail.com, pgsql-bugs@lists.postgresql.org Date: Sat, 26 Sep 2020 15:19:47 +0000 Message-ID: <16637-4374b25aac0e72a4@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 --===============6024745790621001904== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjYzNwpMb2dnZWQgYnk6ICAgICAgICAgIGsyaWJlZ2luIGtkCkVtYWls IGFkZHJlc3M6ICAgICAga3VsbHVhZGhpa2FyaUBnbWFpbC5jb20KUG9zdGdyZVNRTCB2ZXJzaW9u OiAxMi4wCk9wZXJhdGluZyBzeXN0ZW06ICAgTWFjIE9TCkRlc2NyaXB0aW9uOiAgICAgICAgCgpI aSwNCg0KSSBub3RpY2VkIHRoYXQgc29tZXRpbWVzIHRoZSBucGdzcWwgcHJvdmlkZXIgaXMgdGhy b3dpbmcgZXhjZXB0aW9ucwoicmVsYXRpb24gYWxyZWFkeSBleGlzdHMiIHdoZW4gaSB0cnkgdG8g Y3JlYXRlIGEgcGFydGl0aW9uIHdpdGggcGFyYWxsZWwKdGhyZWFkcyBpbiBmdW5jdGlvbmluZy4N Cg0KRXg6DQpwcmludGVkIHNxbCB0aGF0IHJlc3VsdGVkIGluIGV4Y2VwdGlvbiBvbiBjb25zb2xl IDoNCkNSRUFURSBUQUJMRSBJRiBOT1QgRVhJU1RTIE1lc3NhZ2VzXzIwMjBfZF8yNjhfY2lkXzQ1 IFBBUlRJVElPTiBPRg0KInB1YmxpYyIuTWVzc2FnZXNfMjAyMF9kXzI2OCBGT1IgVkFMVUVTIGlu ICg0NSkNCg0KRXhwZWN0YXRpb246DQpleHBlY3RhdGlvbiBpcyB0aGF0IHF1ZXJ5IHNob3VsZCBq dXN0IGV4ZWN1dGUgd2l0aG91dCB0aHJvd2luZyBleGNlcHRpb24sCnRoZSBzYW1lIGJlaGF2aW9y IGFzIGlmIGV4ZWN1dGluZyB0aGUgcXVlcnkgZnJvbSBwZ2FkbWluL3BzcWwuDQoNCkNvZGUNCnZh ciBwYXJ0aXRpb25TcWxTdHJpbmcgPQpCdWlsZENvbm5lY3Rpb25JZEJhc2VkUGFydGl0aW9uKGNv bm5lY3Rpb25JZFBhcnRpdGlvblRhYmxlTmFtZSwKZGF5UGFydGl0aW9uVGFibGVOYW1lLCBjb25u ZWN0aW9uSWQpOw0KYXdhaXQgdXNpbmcgdmFyIGFyY2hpdmVDb250ZXh0ID0gbmV3CkFyY2hpdmVN ZXNzYWdlRGJDb250ZXh0KF9jb25maWd1cmF0aW9uKTsNCnRyeQ0Kew0KYXdhaXQgYXJjaGl2ZUNv bnRleHQuRGF0YWJhc2UuRXhlY3V0ZVNxbFJhd0FzeW5jKHBhcnRpdGlvblNxbFN0cmluZyk7DQp9 DQpjYXRjaCAoRXhjZXB0aW9uIGUpDQp7DQpfbG9nZ2VyLkxvZ0Vycm9yKCQiQ2FuIG5vdCBjcmVh dGUgY29ubmVjdGlvbklEIGxldmVsIDIgcGFydGl0aW9uLCBleGNlcHRpb24Kb2NjdXJlZCB7ZX06 ICIpOw0KX2xvZ2dlci5Mb2dFcnJvcihwYXJ0aXRpb25TcWwpOw0KdGhyb3c7DQp9DQoNClNpbWls YXIgYnVnID8/DQoNCkkgYWxzbyBmb3VuZCBzaW1pbGFyIGJ1ZyBvcGVuZWQgaGVyZQpodHRwczov L3d3dy5wb3N0Z3Jlc3FsLm9yZy9tZXNzYWdlLWlkLzE1OTY4LTA4NTQ5ZTc4ZDUyNjljOTUlNDBw b3N0Z3Jlc3FsLm9yZy4NCg0KYnV0IGRpZCBub3QgZmluZCBhbnkgZm9sbG93IHVwIG9uIGl0LCBz byBpIGFtIG5vdCBzdXJlIGlmIHRoaXMgaXMgdGhlIGJ1ZwpoYXBwZW5pbmcgYXQgcG9zdGdyZXMg bGV2ZWwgT1IgYXQgcHJvdmlkZXIgbGV2ZWwNCg0KU2V0dXANCg0KLk5ldCBDb3JlIDMuMQ0KRWZD b3JlIDMuMS40DQpOcGdTcWwuRW50aXR5RnJhbWV3b3JrQ29yZS5Qb3N0Z3JlU1FMIDMuMS40Cgo= --===============6024745790621001904==--