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 1h6twA-0006NT-DS for pgsql-bugs@arkaria.postgresql.org; Thu, 21 Mar 2019 09:24:34 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1h6tw8-0003dU-O7 for pgsql-bugs@arkaria.postgresql.org; Thu, 21 Mar 2019 09:24:32 +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 1h6tH6-00007d-FA for pgsql-bugs@lists.postgresql.org; Thu, 21 Mar 2019 08:42:08 +0000 Received: from wrigleys.postgresql.org ([2620:122:b000:7::246]) by magus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1h6tH2-00010j-Sw for pgsql-bugs@lists.postgresql.org; Thu, 21 Mar 2019 08:42:08 +0000 Content-Type: multipart/mixed; boundary="===============7134506684603757217==" MIME-Version: 1.0 Subject: BUG #15710: ADD COLUMN IF NOT EXISTS adds constraint anyways To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: thomas@palan.at Reply-To: thomas@palan.at, pgsql-bugs@lists.postgresql.org Date: Thu, 21 Mar 2019 08:41:53 +0000 Message-ID: <15710-f52bad04543be4cb@postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============7134506684603757217== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNTcxMApMb2dnZWQgYnk6ICAgICAgICAgIFRvbSBQYWxhbgpFbWFpbCBh ZGRyZXNzOiAgICAgIHRob21hc0BwYWxhbi5hdApQb3N0Z3JlU1FMIHZlcnNpb246IDkuNi4xMApP cGVyYXRpbmcgc3lzdGVtOiAgIERlYmlhbiBzdHJldGNoIDY0Yml0CkRlc2NyaXB0aW9uOiAgICAg ICAgCgpJZiBJIHdhbnQgdG8gYWRkIGEgY29sdW1uIHRvIGEgdGFibGUgd2hpY2ggYW5kIHRoZSBj b2x1bW4gbWF5IG9yIG1heSBub3QKYWxyZWFkeSBleGlzdCwgdGhlIHNwZWNpZmllZCBjb2x1bW4g Y29uc3RyYWludCBsaWtlIFVOSVFVRSBpcyBhZGRlZCBldmVyeQp0aW1lIHRoZSBjb21tYW5kIGlz IGlzc3VlZCwgcmVnYXJkbGVzcyBpZiB0aGUgY29sdW1uIGdldHMgYWRkZWQgb3Igbm90Lg0KDQpF eGFtcGxlOg0KQ1JFQVRFIFRBQkxFIHRlc3QgKGlkIFNFUklBTCBQUklNQVJZIEtFWSk7DQpBTFRF UiBUQUJMRSB0ZXN0IEFERCBDT0xVTU4gSUYgTk9UIEVYSVNUUyBuZXdfY29sdW1uIGludGVnZXIg VU5JUVVFOw0KDQpSZXN1bHQ6DQpcZCB0ZXN0DQogICAgICAgICAgICAgICAgICAgICAgICAgICBU YWJsZSAicHVibGljLnRlc3QiDQogICBDb2x1bW4gICB8ICBUeXBlICAgfCAgICAgICAgICAgICAg ICAgICAgIE1vZGlmaWVycyAgICAgICAgICAgICAgICAgICAgIA0KLS0tLS0tLS0tLS0tKy0tLS0t LS0tLSstLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0N CiBpZCAgICAgICAgIHwgaW50ZWdlciB8IG5vdCBudWxsIGRlZmF1bHQgbmV4dHZhbCgndGVzdF9p ZF9zZXEnOjpyZWdjbGFzcykNCiBuZXdfY29sdW1uIHwgaW50ZWdlciB8IA0KSW5kZXhlczoNCiAg ICAidGVzdF9wa2V5IiBQUklNQVJZIEtFWSwgYnRyZWUgKGlkKQ0KICAgICJ0ZXN0X25ld19jb2x1 bW5fa2V5IiBVTklRVUUgQ09OU1RSQUlOVCwgYnRyZWUgKG5ld19jb2x1bW4pDQoNCkFmdGVyIGlz c3VpbmcgdGhlIGNvbW1hbmQ6DQpBTFRFUiBUQUJMRSB0ZXN0IEFERCBDT0xVTU4gSUYgTk9UIEVY SVNUUyBuZXdfY29sdW1uIGludGVnZXIgVU5JUVVFOw0KDQphZ2FpbiwgdGhlIHRhYmxlIHN0cnVj dHVyZSBpcyBsaWtlOg0KXGQgdGVzdA0KICAgICAgICAgICAgICAgICAgICAgICAgICAgVGFibGUg InB1YmxpYy50ZXN0Ig0KICAgQ29sdW1uICAgfCAgVHlwZSAgIHwgICAgICAgICAgICAgICAgICAg ICBNb2RpZmllcnMgICAgICAgICAgICAgICAgICAgICANCi0tLS0tLS0tLS0tLSstLS0tLS0tLS0r LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tDQogaWQg ICAgICAgICB8IGludGVnZXIgfCBub3QgbnVsbCBkZWZhdWx0IG5leHR2YWwoJ3Rlc3RfaWRfc2Vx Jzo6cmVnY2xhc3MpDQogbmV3X2NvbHVtbiB8IGludGVnZXIgfCANCkluZGV4ZXM6DQogICAgInRl c3RfcGtleSIgUFJJTUFSWSBLRVksIGJ0cmVlIChpZCkNCiAgICAidGVzdF9uZXdfY29sdW1uX2tl eSIgVU5JUVVFIENPTlNUUkFJTlQsIGJ0cmVlIChuZXdfY29sdW1uKQ0KICAgICJ0ZXN0X25ld19j b2x1bW5fa2V5MSIgVU5JUVVFIENPTlNUUkFJTlQsIGJ0cmVlIChuZXdfY29sdW1uKQ0KDQpSZXN1 bHQ6IGEgbmV3IFVOSVFVRSBjb25zdHJhaW50IHdhcyBhZGRlZA0KRXhwZWN0ZWQgcmVzdWx0OiBh cyB0aGUgY29sdW1uIG5ld19jb2x1bW4gYWxyZWFkeSBleGlzdHMsIGNyZWF0aW5nIHRoZQpjb2x1 bW4gYW5kIHRoZSBzcGVjaWZpZWQgY29uc3RyYWludCBzaG91bGQgbm90IGJlIGRvbmUKCg== --===============7134506684603757217==--