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 1r8MVt-009Tu0-T2 for pgsql-bugs@arkaria.postgresql.org; Wed, 29 Nov 2023 15:30:09 +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 1r8MVs-00BUWU-3O for pgsql-bugs@arkaria.postgresql.org; Wed, 29 Nov 2023 15:30:08 +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 1r8M2q-00BEPi-Dj for pgsql-bugs@lists.postgresql.org; Wed, 29 Nov 2023 15:00: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.94.2) (envelope-from ) id 1r8M2n-009Bhw-QP for pgsql-bugs@lists.postgresql.org; Wed, 29 Nov 2023 15:00: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=BEg33/9+O6GDJ8Oc23vvUc2lqRnM2bjSFOAlkHKLSZQ=; b=7P03joOBplE+ni92PjIOMGl3m3 RJ7iloJaWMaMamRRqOXRf/f6WbdDUYz7w3JDIiTgRTa9nJ0WPIKlBqS8ICMC95rAxsbDOjhgLFBsM CCVGJ9YHrPtNl/dvtKTH0I8XwAY/NOyK2P5enWK9iW8XB9m4i7RNx2x10hCj5OKqu1LByAVE3ARdO sXKp+qq/DbffpDL1/u/pUvPgBgFav2/P1WKaPwSV+LFpgKd5VNtnFoEfqZUYzttR/D2XuzVN07Hgc 11JiwtASd4IfKNw2mJucCzOA3TqIG1SrHnbC4rxnavCGYEy4zr4ZX4KwAifZkJ8RG/3DpyW0w6OY1 vBn4ANqg==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1r8M2m-00AikC-7m for pgsql-bugs@lists.postgresql.org; Wed, 29 Nov 2023 15:00: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 1r8M2j-00DDKb-N2 for pgsql-bugs@lists.postgresql.org; Wed, 29 Nov 2023 15:00:02 +0000 Content-Type: multipart/mixed; boundary="===============3707312068324378072==" MIME-Version: 1.0 Subject: BUG #18217: ALTER TABLE IF EXISTS not being honored with DROP CONSTRAINT IF EXISTS To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: david@buildingfootprintusa.com Reply-To: david@buildingfootprintusa.com, pgsql-bugs@lists.postgresql.org Date: Wed, 29 Nov 2023 14:59:59 +0000 Message-ID: <18217-c7180ab143091145@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 --===============3707312068324378072== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODIxNwpMb2dnZWQgYnk6ICAgICAgICAgIERhdmlkIE1vc3MKRW1haWwg YWRkcmVzczogICAgICBkYXZpZEBidWlsZGluZ2Zvb3RwcmludHVzYS5jb20KUG9zdGdyZVNRTCB2 ZXJzaW9uOiAxNS4yCk9wZXJhdGluZyBzeXN0ZW06ICAgUG9zdGdyZVNRTCAxNS4yIG9uIHg4Nl82 NC1wYy1saW51eC1nbnUKRGVzY3JpcHRpb246ICAgICAgICAKCkkgZm91bmQgdGhpcyBpc3N1ZSBm cm9tIHJ1bm5pbmcgcGdfcmVzdG9yZSB3aXRoIGZsYWdzIHRvIGNsZWFuIGFuZCAiaWYgCmV4aXN0 cyIuICBwZ19yZXN0b3JlIHJldHVybnMgYW4gZXJyb3IgY29kZSB3aGljaCBpcyBnZW5lcmF0ZWQg ZnJvbSBhIHF1ZXJ5Cm9mIHRoZSBmb2xsb3dpbmcgZm9ybToNCg0KQUxURVIgVEFCTEUgSUYgRVhJ U1RTIE9OTFkgcHVibGljLmZvbyBEUk9QIENPTlNUUkFJTlQgSUYgRVhJU1RTIGZvb19wa2V5DQoN CkluIHBnX2FkbWluIHRoaXMgcmVwb3J0czoNCg0KRVJST1I6ICByZWxhdGlvbiAicHVibGljLmZv byIgZG9lcyBub3QgZXhpc3QgDQpTUUwgc3RhdGU6IDQyUDAxDQoNClJ1bm5pbmcgdGhpcyBzYW1l IHF1ZXJ5IGluIGEgMTUuMSBpbnN0YW5jZSByZXR1cm5zIHRoZSBleHBlY3RlZCBiZWhhdmlvcjoN Cg0KTk9USUNFOiAgcmVsYXRpb24gImZvbyIgZG9lcyBub3QgZXhpc3QsIHNraXBwaW5nDQpBTFRF UiBUQUJMRQ0KUXVlcnkgcmV0dXJuZWQgc3VjY2Vzc2Z1bGx5IGluIDQ4IG1zZWMuDQoNCk1vcmUg ZGV0YWlsZWQgdmVyc2lvbiBpbmZvOg0KDQpQb3N0Z3JlU1FMIDE1LjIgb24geDg2XzY0LXBjLWxp bnV4LWdudSwgY29tcGlsZWQgYnkgZ2NjIChHQ0MpIDcuMy4xIDIwMTgwNzEyCihSZWQgSGF0IDcu My4xLTEyKSwgNjQtYml0DQp2cy4NClBvc3RncmVTUUwgMTUuMSwgY29tcGlsZWQgYnkgVmlzdWFs IEMrKyBidWlsZCAxOTE0LCA2NC1iaXQKCg== --===============3707312068324378072==--