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 1pGhZj-00018E-Vx for pgsql-bugs@arkaria.postgresql.org; Sat, 14 Jan 2023 14:32:04 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pGhZi-00019N-Sf for pgsql-bugs@arkaria.postgresql.org; Sat, 14 Jan 2023 14:32:02 +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 1pGbyO-00043c-Lg for pgsql-bugs@lists.postgresql.org; Sat, 14 Jan 2023 08:33:08 +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 1pGbyL-0006Rp-Dh for pgsql-bugs@lists.postgresql.org; Sat, 14 Jan 2023 08:33: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=jf+YnInhrK2D79WBlChMOn9zUILVpL69/eZODezCLY4=; b=5eotoFChWOxCtRrosBu9AXZHq0 eVAzMdjsA9J7tY45cf0GwvR9TW/X6yvVzMN+CUJ7alJtvc18F3xJGrtOxF6cL7Tn+OxQv9SJEYR3x ZXIQCyhde5SVG7iIoYlIEcxp/f7PkYTCJ9ndZqea6ELKFO1S0azd6QjoY64jMBqEWnPiSzg/yU0du QgwjwDjFd+boTyV74l08733atAoB8ivoiKKqbGjbVLwanH4mNtqeZlMq1EocNn4dA5LgDFAqhgpcs V7DxvUJNofEvpOdSgPQa5A7llDk3zz7LASO0NZ+FDJD5Wbs55O+YHOaeauQYEKlPPD436/20noGVq pRI+mT+A==; 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 1pGbyL-0003Wa-09 for pgsql-bugs@lists.postgresql.org; Sat, 14 Jan 2023 08:33:05 +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 1pGbyH-00DXTw-CR for pgsql-bugs@lists.postgresql.org; Sat, 14 Jan 2023 08:33:02 +0000 Content-Type: multipart/mixed; boundary="===============6279836171035829957==" MIME-Version: 1.0 Subject: BUG #17751: DDL CREATE statement accepts invalid default values for FOREIGN KEY constraint. To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: sky.sravan@gmail.com Reply-To: sky.sravan@gmail.com, pgsql-bugs@lists.postgresql.org Date: Sat, 14 Jan 2023 08:32:15 +0000 Message-ID: <17751-30191fe0c6b1e981@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 --===============6279836171035829957== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzc1MQpMb2dnZWQgYnk6ICAgICAgICAgIFNyYXZhbiBLdW1hcgpFbWFp bCBhZGRyZXNzOiAgICAgIHNreS5zcmF2YW5AZ21haWwuY29tClBvc3RncmVTUUwgdmVyc2lvbjog MTUuMQpPcGVyYXRpbmcgc3lzdGVtOiAgIFdpbmRvd3MgMTAKRGVzY3JpcHRpb246ICAgICAgICAK ClZFUlNJT046ICJQb3N0Z3JlU1FMIDE1LjEsIGNvbXBpbGVkIGJ5IFZpc3VhbCBDKysgYnVpbGQg MTkxNCwgNjQtYml0Ig0KDQotLUJ1ZyByZXBvcnRpbmcgT04gRm9yZWlnbiBrZXkgY29uc3RyYWlu dCAiT04gREVMRVRFIFNFVCBERUZBVUxUIg0KDQotLSBjcmF0ZSBhIHVzZXJzIHRhYmxlDQpDUkVB VEUgVEFCTEUgdXNlcnMoDQoJaWQgU0VSSUFMIFBSSU1BUlkgS0VZLA0KCXVzZXJuYW1lIFZBUkNI QVIoNTApDQopOw0KDQotLUluc2VydCB2YWx1ZXMgaW50byB0aGUgdXNlcnMgdGFibGUNCklOU0VS VCBJTlRPIHVzZXJzKHVzZXJuYW1lKQ0KCVZBTFVFUyAoJ21vbmFoYW45MycpLCgncGZlZmZlcicp LCgnOTlzdHJvbWFuJyksKCdzaW0zb25pcycpOw0KDQotLURpc3BsYXkgdGhlIHZhbHVlcyB0byBj aGVjayB0aGUgaW5zZXJ0aW9uIG9mIGRhdGEgaW50byB1c2VycyB0YWJsZQ0KU0VMRUNUICogRlJP TSB1c2VyczsNCg0KLS1DcmVhdGUgYSB0YWJsZSBwaG90b3M7DQotLSBzZXQgdGhlIGRlZmF1bHQg dmFsdWUgb2YgdGhlIGZvcmVpZ24ga2V5IGFzIDUwIHdoaWNoIGRvZXMgbm90IGV4aXN0IGluCnRo ZSB1c2VycyB0YWJsZQ0KQ1JFQVRFIFRBQkxFIHBob3RvcygNCglpZCBTRVJJQUwgUFJJTUFSWSBL RVksDQoJdXJsIFZBUkNIQVIoMjAwKSwNCgl1c2VyX2lkIElOVEVHRVIgREVGQVVMVCA1MCBSRUZF UkVOQ0VTIHVzZXJzKGlkKSBPTiBERUxFVEUgU0VUIERFRkFVTFQNCik7DQoNCi0tSW5zZXJ0IHZh bHVlcyBpbnRvIHRoZSBwaG90b3MgdGFibGUNCklOU0VSVCBJTlRPIHBob3Rvcyh1cmwsdXNlcl9p ZCkNClZBTFVFUw0KKCdodHRwOi8vYnl0ZWJ1ZC5jb20vMS5qcGcnLDQpLA0KKCdodHRwczovL2J5 dGVidWQuY29tLzMyNC5qcGcnLDEpLA0KKCdodHRwczovL2J5dGVidWQuY29tLzM0LmpwZycsMyks DQooJ2h0dHBzOi8vYnl0ZWJ1ZC5jb20vNTE0LmpwZycsMiksDQooJ2h0dHBzOi8vYnl0ZWJ1ZC5j b20vODU0LmpwZycsMSksDQooJ2h0dHBzOi8vYnl0ZWJ1ZC5jb20vOTUuanBnJywxKSwNCignaHR0 cHM6Ly9ieXRlYnVkLmNvbS8zOC5qcGcnLDQpLA0KKCdodHRwOi8vYnl0ZWJ1ZC5jb20vODMxLmpw ZycsTlVMTCk7DQoNCi0tRGlzcGxheSB0aGUgdmFsdWVzIHRvIGNoZWNrIHRoZSBpbnNlcnRpb24g b2YgZGF0YSBpbnRvIHBob3RvcyB0YWJsZQ0KU0VMRUNUICogRlJPTSBwaG90b3M7DQoNCi0tSUYg d2UgdHJ5IHRvIGRlbGV0ZSBhbnkgdXNlciwgd2Ugd2lsbCBnZXQgYW4gZXJyb3IgbWVzc2FnZQ0K REVMRVRFIEZST00gdXNlcnMgV0hFUkUgaWQ9NDsNCg0KRVJST1I6ICBpbnNlcnQgb3IgdXBkYXRl IG9uIHRhYmxlICJwaG90b3MiIHZpb2xhdGVzIGZvcmVpZ24ga2V5IGNvbnN0cmFpbnQKInBob3Rv c191c2VyX2lkX2ZrZXkiDQpERVRBSUw6ICBLZXkgKHVzZXJfaWQpPSgxKSBpcyBub3QgcHJlc2Vu dCBpbiB0YWJsZSAidXNlcnMiLg0KU1FMIHN0YXRlOiAyMzUwMwoK --===============6279836171035829957==--