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 1lH2jO-0007fx-7W for pgsql-bugs@arkaria.postgresql.org; Tue, 02 Mar 2021 10:58:22 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lH2jK-00043n-Pr for pgsql-bugs@arkaria.postgresql.org; Tue, 02 Mar 2021 10:58:18 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lH2Mt-0004cT-3u for pgsql-bugs@lists.postgresql.org; Tue, 02 Mar 2021 10:35:07 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lH2Mq-0004se-AN for pgsql-bugs@lists.postgresql.org; Tue, 02 Mar 2021 10:35:06 +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=tz9g+YnKXrWVqugj4AB7P+/ZXOPrYQ0oAVH5Tb3R9sI=; b=UOi0t2jK7mmHjbgOgxKnkHVSnC UF76LBHgEQWxGOIs9BK5LUURALYSk6YaMWk1SHMXoUYHH5WMFe6tBYA743By0GYg/UDvo4qbfkrFA BGvWmrZoufEuVDTECt09T/lETmyOzeqlx296V8PAE3ososQtbL1N7Hd97P8+VDGBuebPWmA6uFBsY Sdu88HkQgrr8CR8eYepnkrRn/SbZIBs1xpQ53HKlxout3+hTiJN/MN1zeqziIxvYwGOGf13+B3x/G VRocuNOcg0ED8yPBiydIU+f1VT1X3ei2rqiAK781+WHuojJ5XK7f3BTkpp8qXMNWBqQIG2zWrnB8r MW+0Oe3g==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lH2Mp-0002Ie-Jf for pgsql-bugs@lists.postgresql.org; Tue, 02 Mar 2021 10:35:03 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lH2Mo-0005Bs-6D for pgsql-bugs@lists.postgresql.org; Tue, 02 Mar 2021 10:35:02 +0000 Content-Type: multipart/mixed; boundary="===============9138867335275965984==" MIME-Version: 1.0 Subject: BUG #16909: On update (not insert) the attisdropped flag is set for tables which are recreated with the same col To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: grumpylittleted@googlemail.com Reply-To: grumpylittleted@googlemail.com, pgsql-bugs@lists.postgresql.org Date: Tue, 02 Mar 2021 10:34:55 +0000 Message-ID: <16909-3a6da1ab19f5652b@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 --===============9138867335275965984== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjkwOQpMb2dnZWQgYnk6ICAgICAgICAgIEdydW1weWxpdHRsZXRlZApF bWFpbCBhZGRyZXNzOiAgICAgIGdydW1weWxpdHRsZXRlZEBnb29nbGVtYWlsLmNvbQpQb3N0Z3Jl U1FMIHZlcnNpb246IDEzLjIKT3BlcmF0aW5nIHN5c3RlbTogICBMaW51eCA1LjguMC00NC1nZW5l cmljICM1MH4yMC4wNC4xLVVidW50dSBTCkRlc2NyaXB0aW9uOiAgICAgICAgCgovKg0KDQogIEJV RzoNCg0KICBVc2luZyAxMy4yDQogIE9uIHVwZGF0ZSAobm90IGluc2VydCkgdGhlIGF0dGlzZHJv cHBlZCBmbGFnIGlzIHNldCBmb3IgdGFibGVzIHdoaWNoIGFyZQpyZWNyZWF0ZWQgd2l0aCB0aGUg c2FtZSBjb2x1bW4gbmFtZXMgYXMgdGhlIG9yaWdpbmFsIGJ1dCB3aGVyZSBwcmVjZWRpbmcKY29s dW1ucyBoYXZlIGJlZW4gZHJvcHBlZA0KDQogIE1FVEhPRDoNCiAgQ3JlYXRlIGEgdGFibGUgdCB3 aXRoIG1vcmUgdGhhbiB0d28gY29sdW1uczogeCwgeSwgeg0KICBEcm9wIHRoYXQgdGFibGUNCiAg Q3JlYXRlIGEgdGFibGUgdCB3aXRoIGEgc3Vic2V0IG9mIHRoZSBjb2x1bW5zIHdpdGggdGhlIHNh bWUgbmFtZSBhcyB0aGUKcHJldmlvdXMgdGFibGU6IGhlcmUgd2UgcmVtb3ZlIHkNCiAgSW5zZXJ0 IGEgbmV3IHJvdzogdGhlcmUgYXJlIHR3byBhdHRyaWJ1dGVzIChjb3JyZWN0KSwgbmVpdGhlciBv ZiB3aGljaApoYXZlIHRoZSBhdHRpc2Ryb3BwZWQgZmxhZyBzZXQgKGNvcnJlY3QpIChzbyBidWcg bm90IGFwcGFyZW50IHdpdGgKaW5zZXJ0cykNCiAgVXBkYXRlIHRoZSByb3c6IHRoZXJlIGFyZSB0 d28gYXR0cmlidXRlcyAoY29ycmVjdCksIHRoZSBmaXJzdCBhdHRyaWJ1dGUKaGFzIHRoZSBhdHRp c2Ryb3BwZWQgZmxhZyB1bnNldCAoY29ycmVjdCkgQlVUIHRoZSBzZWNvbmQgYXR0cmlidXRlIGhh cyB0aGUKYXR0aXNkcm9wcGVkIGZsYWcgc2V0IChpbmNvcnJlY3QpDQoNCg0KDQogIG1ha2UgDQog IHN1ZG8gY3AgLi9mLnNvIGBwZ19jb25maWcgLS1wa2dsaWJkaXJgDQoNCg0KICBTUUw6DQoNCiAg Y3JlYXRlIG9yIHJlcGxhY2UgZnVuY3Rpb24gZigpIHJldHVybnMgdHJpZ2dlciBhcyAnLi9mLnNv JywnZicgbGFuZ3VhZ2UgYwpzdHJpY3Q7DQoNCiAgZHJvcCB0YWJsZSBpZiBleGlzdHMgdCBjYXNj YWRlOw0KICBjcmVhdGUgdGFibGUgdCh4IGludCwgeSBpbnQsIHogaW50KTsNCg0KICBkcm9wIHRh YmxlIHQgY2FzY2FkZTsNCiAgY3JlYXRlIHRhYmxlIHQoeCBpbnQsIHogaW50KTsNCiAgY3JlYXRl IHRyaWdnZXIgdGYgYmVmb3JlIGluc2VydCBvciB1cGRhdGUgb24gdCBmb3IgZWFjaCByb3cgZXhl Y3V0ZQpwcm9jZWR1cmUgZigpOw0KICBpbnNlcnQgaW50byB0IHZhbHVlcyg0LDUpOyAtLSBhdHRy IG51bT0xIGF0dGlzZHJvcHBlZD0wDQogIHVwZGF0ZSB0IHNldCB4PTI7DQoNCg0KDQoNCiovDQoN CiNpbmNsdWRlIDxzdGRsaWIuaD4NCiNpbmNsdWRlIDxzdGRpby5oPg0KI2luY2x1ZGUgPGxpbWl0 cy5oPg0KI2luY2x1ZGUgInBvc3RncmVzLmgiDQojaW5jbHVkZSAiZm1nci5oIg0KI2luY2x1ZGUg ImV4ZWN1dG9yL3NwaS5oIg0KI2luY2x1ZGUgImNvbW1hbmRzL3RyaWdnZXIuaCINCiNpbmNsdWRl ICJ1dGlscy9yZWwuaCINCiNpbmNsdWRlICJ1dGlscy9mbWdycHJvdG9zLmgiDQoNCg0KDQpQR19N T0RVTEVfTUFHSUM7DQpQR19GVU5DVElPTl9JTkZPX1YxKCBmICk7DQpEYXR1bSBmKCBQR19GVU5D VElPTl9BUkdTICkgew0KDQogIFRyaWdnZXJEYXRhICp0cmlnZGF0YSA9ICggVHJpZ2dlckRhdGEg KiApIGZjaW5mby0+Y29udGV4dDsNCiAgY29uc3QgVHVwbGVEZXNjIHR1cGRlc2MgPSB0cmlnZGF0 YS0+dGdfcmVsYXRpb24tPnJkX2F0dDsNCiAgSGVhcFR1cGxlIHR1cGxlID0gVFJJR0dFUl9GSVJF RF9CWV9VUERBVEUoIHRyaWdkYXRhLT50Z19ldmVudCApID8KdHJpZ2RhdGEtPnRnX25ld3R1cGxl IDogdHJpZ2RhdGEtPnRnX3RyaWd0dXBsZTsNCg0KICBmb3IoIGludCBpID0gMTsgaSA8PSB0dXBk ZXNjLT5uYXR0czsgaSsrICkgew0KICAgIGVsb2coIElORk8sICJhdHRyIG51bT0lZCBhdHRpc2Ry b3BwZWQ9JWQiLCBpLCBUdXBsZURlc2NBdHRyKCB0dXBkZXNjLCBpCiktPmF0dGlzZHJvcHBlZCAp Ow0KICB9DQoNCiAgcmV0dXJuIFBvaW50ZXJHZXREYXR1bSggdHVwbGUgKTsNCg0KfQoK --===============9138867335275965984==--