Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1he3Sg-0001te-EZ for pgsql-bugs@arkaria.postgresql.org; Thu, 20 Jun 2019 20:15:10 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1he3Sf-0008KZ-BT for pgsql-bugs@arkaria.postgresql.org; Thu, 20 Jun 2019 20:15:09 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1he3Sf-0008HJ-20 for pgsql-bugs@lists.postgresql.org; Thu, 20 Jun 2019 20:15:09 +0000 Received: from wrigleys.postgresql.org ([2620:122:b000:7::246]) by magus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1he3Sc-0003zl-JN for pgsql-bugs@lists.postgresql.org; Thu, 20 Jun 2019 20:15:08 +0000 Content-Type: multipart/mixed; boundary="===============7455180874185356369==" MIME-Version: 1.0 Subject: BUG #15865: ALTER TABLE statements causing "relation already exists" errors when some indexes exist To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: keith.fiske@crunchydata.com Reply-To: keith.fiske@crunchydata.com, pgsql-bugs@lists.postgresql.org Date: Thu, 20 Jun 2019 20:14:29 +0000 Message-ID: <15865-17940eacc8f8b081@postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============7455180874185356369== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNTg2NQpMb2dnZWQgYnk6ICAgICAgICAgIEtlaXRoIEZpc2tlCkVtYWls IGFkZHJlc3M6ICAgICAga2VpdGguZmlza2VAY3J1bmNoeWRhdGEuY29tClBvc3RncmVTUUwgdmVy c2lvbjogMTEuNApPcGVyYXRpbmcgc3lzdGVtOiAgIENlbnRPUzcKRGVzY3JpcHRpb246ICAgICAg ICAKCldoZW4gdGVzdGluZyB0aGUgc2V0dXAgb2Ygb3VyIG1vbml0b3JpbmcgcGxhdGZvcm0sIHdl IHN0YXJ0ZWQgcnVubmluZyBpbnRvCmFuIGVycm9yIHdoZW4gdXNpbmcgUG9zdGdyZVNRTCBhcyBh IGJhY2tlbmQgZm9yIEdyYWZhbmEuIFdlIG5hcnJvd2VkIGRvd24KdGhlIGlzc3VlIHRvIG9ubHkg b2NjdXJyaW5nIHdpdGggdGhlIGxhdGVzdCBwb2ludCByZWxlYXNlIG9mIFBHLApzcGVjaWZpY2Fs bHkgMTEuNCwgMTAuOSBhbmQgOS42LjE0IChwcmV2aW91cyBtYWpvciB2ZXJzaW9ucyB3ZXJlIG5v dCB0ZXN0ZWQKYXQgdGhpcyB0aW1lKS4gVGhlIGlzc3VlIGNhbiBiZSByZWNyZWF0ZWQgYnkgZm9s bG93aW5nIHRoZSBzZXR1cCBzdGVwcyBmb3IKR3JhZmFuYSB3aXRoIGEgUEcgYmFja2VuZCBhbmQg aXQgd2lsbCBvY2N1ciB3aGVuIHRoZSBHcmFmYW5hIHNlcnZpY2UgaXMKc3RhcnRlZCBmb3IgdGhl IGZpcnN0IHRpbWUgYW5kIGl0IHRyaWVzIHRvIHNldCB1cCBpdHMgc2NoZW1hIGluIFBHLiBXZSBk bwpub3Qgc2VlIHRoZSBlcnJvciBvY2N1cnJpbmcgd2l0aCB0aGUgcHJldmlvdXMgbWlub3IgdmVy c2lvbnMgKDExLjMsIDEwLjgsCjkuNi4xMykuDQoNCkEgc3RhbmRhbG9uZSwgcmVwcm9kdWNpYmxl IHVzZS1jYXNlIGlzIGFzIGZvbGxvd3MuIFRoZSBmaW5hbCwgQUxURVIgVEFCTEUKc3RhdGVtZW50 ICh3aGljaCBpcyBnZW5lcmF0ZWQgYnkgR3JhZmFuYSkgd2lsbCBjYXVzZSB0aGUgZXJyb3I6DQoN Ci0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tDQpFUlJPUjogIHJlbGF0aW9uICJVUUVfdXNl cl9sb2dpbiIgYWxyZWFkeSBleGlzdHMNCi0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tDQoN Ckhvd2V2ZXIgaWYgZWFjaCBBTFRFUiBDT0xVTU4gc3RhdGVtZW50IGlzIHJ1biBpbmRlcGVuZGVu dGx5LCBpdCBzZWVtcyB0bwp3b3JrIGZpbmUuDQoNCi0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tDQpDUkVBVEUgVEFCTEUgcHVibGljLiJ1c2VyIiAoDQogICAgaWQgaW50ZWdlciBOT1QgTlVM TCwNCiAgICB2ZXJzaW9uIGludGVnZXIgTk9UIE5VTEwsDQogICAgbG9naW4gY2hhcmFjdGVyIHZh cnlpbmcoMTkwKSBOT1QgTlVMTCwNCiAgICBlbWFpbCBjaGFyYWN0ZXIgdmFyeWluZygxOTApIE5P VCBOVUxMLA0KICAgIG5hbWUgY2hhcmFjdGVyIHZhcnlpbmcoMjU1KSwNCiAgICBwYXNzd29yZCBj aGFyYWN0ZXIgdmFyeWluZygyNTUpLA0KICAgIHNhbHQgY2hhcmFjdGVyIHZhcnlpbmcoNTApLA0K ICAgIHJhbmRzIGNoYXJhY3RlciB2YXJ5aW5nKDUwKSwNCiAgICBjb21wYW55IGNoYXJhY3RlciB2 YXJ5aW5nKDI1NSksDQogICAgb3JnX2lkIGJpZ2ludCBOT1QgTlVMTCwNCiAgICBpc19hZG1pbiBi b29sZWFuIE5PVCBOVUxMLA0KICAgIGVtYWlsX3ZlcmlmaWVkIGJvb2xlYW4sDQogICAgdGhlbWUg Y2hhcmFjdGVyIHZhcnlpbmcoMjU1KSwNCiAgICBjcmVhdGVkIHRpbWVzdGFtcCB3aXRob3V0IHRp bWUgem9uZSBOT1QgTlVMTCwNCiAgICB1cGRhdGVkIHRpbWVzdGFtcCB3aXRob3V0IHRpbWUgem9u ZSBOT1QgTlVMTCwNCiAgICBoZWxwX2ZsYWdzMSBiaWdpbnQgREVGQVVMVCAwIE5PVCBOVUxMDQop Ow0KDQpDUkVBVEUgU0VRVUVOQ0UgcHVibGljLnVzZXJfaWRfc2VxMQ0KICAgIEFTIGludGVnZXIN CiAgICBTVEFSVCBXSVRIIDENCiAgICBJTkNSRU1FTlQgQlkgMQ0KICAgIE5PIE1JTlZBTFVFDQog ICAgTk8gTUFYVkFMVUUNCiAgICBDQUNIRSAxOw0KDQpBTFRFUiBUQUJMRSBPTkxZIHB1YmxpYy4i dXNlciIgQUxURVIgQ09MVU1OIGlkIFNFVCBERUZBVUxUCm5leHR2YWwoJ3B1YmxpYy51c2VyX2lk X3NlcTEnOjpyZWdjbGFzcyk7DQoNClNFTEVDVCBwZ19jYXRhbG9nLnNldHZhbCgncHVibGljLnVz ZXJfaWRfc2VxMScsIDEsIGZhbHNlKTsNCg0KQUxURVIgVEFCTEUgT05MWSBwdWJsaWMuInVzZXIi IEFERCBDT05TVFJBSU5UIHVzZXJfcGtleTEgUFJJTUFSWSBLRVkgKGlkKTsNCg0KQ1JFQVRFIFVO SVFVRSBJTkRFWCAiVVFFX3VzZXJfZW1haWwiIE9OIHB1YmxpYy4idXNlciIgVVNJTkcgYnRyZWUg KGVtYWlsKTsNCg0KQ1JFQVRFIFVOSVFVRSBJTkRFWCAiVVFFX3VzZXJfbG9naW4iIE9OIHB1Ymxp Yy4idXNlciIgVVNJTkcgYnRyZWUgKGxvZ2luKTsNCg0KQUxURVIgVEFCTEUgInVzZXIiIEFMVEVS ICJsb2dpbiIgVFlQRSBWQVJDSEFSKDE5MCksIEFMVEVSICJlbWFpbCIgVFlQRQpWQVJDSEFSKDE5 MCksIEFMVEVSICJuYW1lIiBUWVBFIFZBUkNIQVIoMjU1KSwgQUxURVIgInBhc3N3b3JkIiBUWVBF ClZBUkNIQVIoMjU1KSwgQUxURVIgInNhbHQiIFRZUEUgVkFSQ0hBUig1MCksIEFMVEVSICJyYW5k cyIgVFlQRSBWQVJDSEFSKDUwKSwKQUxURVIgImNvbXBhbnkiIFRZUEUgVkFSQ0hBUigyNTUpLCBB TFRFUiAidGhlbWUiIFRZUEUgVkFSQ0hBUigyNTUpOw0KLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0KCg== --===============7455180874185356369==--