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 1nT0RT-00019U-Oi for pgsql-bugs@arkaria.postgresql.org; Sat, 12 Mar 2022 12:01:52 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nT0RR-00078g-VV for pgsql-bugs@arkaria.postgresql.org; Sat, 12 Mar 2022 12:01:49 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nSovX-0000Y8-46 for pgsql-bugs@lists.postgresql.org; Fri, 11 Mar 2022 23:44:07 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nSovU-0002JU-TU for pgsql-bugs@lists.postgresql.org; Fri, 11 Mar 2022 23:44: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=tkxiQ2bbGKxxKHt1i0gVH66TDMeA1ObG52ZsvIuroA0=; b=f8X5VfKuAKnAr3Xn7N+yLzDTWa 3nm9AZ+TMc1UC5+h7Lic1sfLXDElF/NBgPmgH+mJ7s992awNHTBrV9NMVj3TMRYAXccb1antZA+2A 1Ke49jjEUg74pgIZ8w0DP/Nf6zpPaQ6UVoDfHJcKQArpA380yMuAY0wYrGp0O0nFzTIKDuNxdE7Yh 94T7+1h8zyvv/JiTNL5acpsVSJJUeqV+U8sMLqrXlYq+JjB+P38e0XJWIYKlYv+vpR9DCdbNMi4NJ 4XmVaUofNeARXIf/+U/afccJVdWhKoiln7lwthHm/MqAvgq9kesXU1yQy1T4L8gTSlOY4EnBMv3yy xDmQBtEQ==; 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 1nSovT-0006aO-HX for pgsql-bugs@lists.postgresql.org; Fri, 11 Mar 2022 23:44:03 +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 1nSovR-001NiY-7e for pgsql-bugs@lists.postgresql.org; Fri, 11 Mar 2022 23:44:02 +0000 Content-Type: multipart/mixed; boundary="===============3909364549501611222==" MIME-Version: 1.0 Subject: BUG #17435: "add column if not exists" always adds new FK on the column To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: rafmsou@gmail.com Reply-To: rafmsou@gmail.com, pgsql-bugs@lists.postgresql.org Date: Fri, 11 Mar 2022 23:43:40 +0000 Message-ID: <17435-9cd1c9fedec5bfe5@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 --===============3909364549501611222== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzQzNQpMb2dnZWQgYnk6ICAgICAgICAgIFJhZmFlbCBTb3VzYQpFbWFp bCBhZGRyZXNzOiAgICAgIHJhZm1zb3VAZ21haWwuY29tClBvc3RncmVTUUwgdmVyc2lvbjogMTIu MTAKT3BlcmF0aW5nIHN5c3RlbTogICBtYWNPUywgbGludXgKRGVzY3JpcHRpb246ICAgICAgICAK ClRoZSBzdGF0ZW1lbnQgYmVsb3cgYWltcyB0byBhZGQgYSBuZXcgY29sdW1uIENDQyBvbiB0YWJs ZSBYWFggYW5kIGNyZWF0ZSBhCkZLIGNvbnN0cmFpbnQgdG8gWVlZIGF0IHRoZSBzYW1lIHRpbWU6 DQoNCiJhbHRlciB0YWJsZSBYWFggYWRkIGNvbHVtbiBpZiBub3QgZXhpc3RzIENDQyB1dWlkIHJl ZmVyZW5jZXMgWVlZIChpZCk7Ig0KDQpJIGNoZWNrZWQgdGhlIGRvY3MgYW5kIG90aGVyIGZvcnVt IGFuZCB0aGF0IHNlZW1zIHRvIGJlIHBvc3NpYmxlLiBUaGUKcHJvYmxlbSBpcyB0aGF0IHdlIGVu ZCB1cCB3aXRoIG11bHRpcGxlIEZLcyBjcmVhdGVkIG9uIGNvbHVtbiBDQ0Mgd2hlbg0KcnVubmlu ZyB0aGUgc3RhdGVtZW50IG11bHRpcGxlIHRpbWVzLiBJIHdvdWxkIGhvcGUgbm8gRksgZ2V0cyBj cmVhdGVkIHdoZW4KdGhlIGNvbHVtbiBhbHJlYWR5IGV4aXN0cywgaXMgdGhhdCBjb3JyZWN0PwoK --===============3909364549501611222==--