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 1icnK9-0007X8-Rs for pgsql-bugs@arkaria.postgresql.org; Thu, 05 Dec 2019 09:21:25 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1icnK8-00032V-Mp for pgsql-bugs@arkaria.postgresql.org; Thu, 05 Dec 2019 09:21:24 +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 1icnH3-0007N9-Sc for pgsql-bugs@lists.postgresql.org; Thu, 05 Dec 2019 09:18:13 +0000 Received: from wrigleys.postgresql.org ([2620:122:b000:7::246]) by magus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1icnGv-0002KU-SX for pgsql-bugs@lists.postgresql.org; Thu, 05 Dec 2019 09:18:12 +0000 Content-Type: multipart/mixed; boundary="===============5903989388361848027==" MIME-Version: 1.0 Subject: BUG #16150: UPDATE set NULL value in non-null columns To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: maximaximax@gmail.com Reply-To: maximaximax@gmail.com, pgsql-bugs@lists.postgresql.org Date: Thu, 05 Dec 2019 09:17:34 +0000 Message-ID: <16150-dc6886080d71e985@postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============5903989388361848027== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjE1MApMb2dnZWQgYnk6ICAgICAgICAgIE1heGltIFZvdHlha292CkVt YWlsIGFkZHJlc3M6ICAgICAgbWF4aW1heGltYXhAZ21haWwuY29tClBvc3RncmVTUUwgdmVyc2lv bjogMTIuMApPcGVyYXRpbmcgc3lzdGVtOiAgIFdpbmRvd3MKRGVzY3JpcHRpb246ICAgICAgICAK CkhpIGd1eXMNCg0KVG9kYXkgSSBmb3VuZCBhIGJpZyBwcm9ibGVtLCBJIGNhbiB3cml0ZSBhIHZh bGlkIFVQREFURSB3aGljaCBwdXQgTlVMTCB2YWx1ZQppbiBub24tbnVsbCBjb2x1bW4uDQoNCkxl dCdzIGNyZWF0ZSBhIGRvbWFpbiwgdHdvIHRhYmxlcyBhbmQgaW5zZXJ0IDEgcm93IGludG8gdGhl bToNCg0KY3JlYXRlIGRvbWFpbiBkX3RleHRfbm90X251bGwgYXMgdGV4dCBkZWZhdWx0ICcnIG5v dCBudWxsOw0KDQpjcmVhdGUgdGFibGUgcGVyc29uIChuYW1lIGRfdGV4dF9ub3RfbnVsbCk7DQpj cmVhdGUgdGFibGUgdG93biAobmFtZSBkX3RleHRfbm90X251bGwpOw0KDQppbnNlcnQgaW50byBw ZXJzb24obmFtZSkgdmFsdWVzICgndGVzdCcpOw0KaW5zZXJ0IGludG8gdG93bihuYW1lKSB2YWx1 ZXMgKCd0ZXN0MicpOw0KDQpzZWxlY3QgKiBmcm9tIHBlcnNvbjsgLS0gMSByb3cgd2l0aCB2YWx1 ZSB0ZXN0ICANCg0KTm93IGxldCdzIHRyeSB0byB1cGRhdGUgcGVyc29uIG5hbWUgdG8gbnVsbC4g SXQgZmFpbGVkIGFuZCBpdCBpcyBjb3JyZWN0Og0KDQp1cGRhdGUgcGVyc29uIHNldCBuYW1lID0g bnVsbDsgLS0gU1FMIEVycm9yIFsyMzUwMl06IEVSUk9SOiBkb21haW4KZF90ZXh0X25vdF9udWxs IGRvZXMgbm90IGFsbG93IG51bGwgdmFsdWVzDQoNCkJ1dCBub3cgbGV0J3MgdHJ5IHRvIHVwZGF0 ZSBwZXJzb24gbmFtZSB0byB3aXRoIHN1Yi1xdWVyeS4gSXQgdXBkYXRlcyBhIHJvdwp3aXRob3V0 IGFueSBwcm9ibGVtOg0KDQp1cGRhdGUgcGVyc29uIHNldCBuYW1lID0gKHNlbGVjdCBuYW1lIGZy b20gdG93biB3aGVyZSBuYW1lID0gJ3dyb25nJyk7IC0tIDEKcm93IHVwZGF0ZWQNCg0KTGV0J3Mg Y2hlY2sgZGF0YSBhbmQgc2VlIHRoZSByZXN1bHQ6DQoNCnNlbGVjdCAqIGZyb20gcGVyc29uOyAt LSAxIHJvdyB3aXRoIHZhbHVlIE5VTEwgaW4gbm9uLW51bGwgY29sdW1uICEhIQ0KDQpJIHRoaW5r IGl0IGlzIHZlcnkgZGFuZ2Vyb3VzIGFuZCBpbXBvcnRhbnQgYnVnIGFuZCBpdCBoYXMgdG8gYmUg Zml4ZWQgdG8gbm90CmRhbWFnZSBkYXRhIGluIGRhdGFiYXNlcyAtIGlmIEkgYmFja3VwL3Jlc3Rv cmUgc3VjaCB0YWJsZXMgdGhleSBiZWNvbWUKZW1wdHkuCgo= --===============5903989388361848027==--