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 1jRHeF-0007FU-Kc for pgsql-sql@arkaria.postgresql.org; Wed, 22 Apr 2020 15:50: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 1jRHeE-0007kX-IN for pgsql-sql@arkaria.postgresql.org; Wed, 22 Apr 2020 15:50:50 +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 1jRHeE-0007kQ-AQ for pgsql-sql@lists.postgresql.org; Wed, 22 Apr 2020 15:50:50 +0000 Received: from forward501o.mail.yandex.net ([2a02:6b8:0:1a2d::611]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jRHeA-0000xq-OV for pgsql-sql@lists.postgresql.org; Wed, 22 Apr 2020 15:50:49 +0000 Received: from mxback30j.mail.yandex.net (mxback30j.mail.yandex.net [IPv6:2a02:6b8:0:1619::230]) by forward501o.mail.yandex.net (Yandex) with ESMTP id 4B6DA1E80AD2; Wed, 22 Apr 2020 18:50:42 +0300 (MSK) Received: from localhost (localhost [::1]) by mxback30j.mail.yandex.net (mxback/Yandex) with ESMTP id dourEILe0G-oeVmQOSH; Wed, 22 Apr 2020 18:50:41 +0300 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=reddoc.net; s=mail; t=1587570641; bh=lQtpENC3ioluzL06T0Zd9mDGGfd5bJs/lyFdSFzB3+w=; h=References:Date:Message-Id:Subject:In-Reply-To:To:From; b=Onj0Ne6uo4P+acOW13QPnZTeIz1oVyTqrgUsqAaoWe9l1N3nSWhNmArGec63er3cK 7nYE7M7S2wmTCkulvgfdojBcNNUmg1U26pSPCTz+88PJdyWYWQZI6g/x/ekTlriWvZ Li7ENKgVKjLL5OGw0V9xU1diXxouRtZUYtAPrXjs= Authentication-Results: mxback30j.mail.yandex.net; dkim=pass header.i=@reddoc.net Received: by iva3-67f911cb3a01.qloud-c.yandex.net with HTTP; Wed, 22 Apr 2020 18:50:40 +0300 From: Samed YILDIRIM To: "Heinemann, Manfred (IMS)" , "pgsql-sql@lists.postgresql.org" In-Reply-To: References: Subject: Re: FK constraint question MIME-Version: 1.0 X-Mailer: Yamail [ http://yandex.ru ] 5.0 Date: Wed, 22 Apr 2020 18:50:40 +0300 Message-Id: <580931587570375@mail.yandex.com.tr> Content-Transfer-Encoding: base64 Content-Type: text/html; charset=utf-8 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk PGRpdj5IZWxsbyBNYW5mcmVkLDwvZGl2PjxkaXY+wqA8L2Rpdj48ZGl2PkRpZCB0aGUgdGFibGUg bmFtZWQgPGVtPnRhc2s8L2VtPiBoYXZlIGNoaWxkIHRhYmxlcz8gVGhlIHJlY29yZHMgd2hvc2Ug dGFza19pZCB3YXMgMSB3ZXJlIGluIGNoaWxkIHRhYmxlcyByYXRoZXIgdGhhbiA8ZW0+dGFzaz88 L2VtPjwvZGl2PjxkaXY+wqA8L2Rpdj48ZGl2PkNvdWxkIHlvdSBwbGVhc2UgdHJ5IGZvbGxvd2lu ZyBxdWVyeT88L2Rpdj48ZGl2PsKgPC9kaXY+PGRpdj48cCBzdHlsZT0iZm9udC1mYW1pbHk6J2Nh bGlicmknICwgc2Fucy1zZXJpZjtmb250LXNpemU6MTFwdDttYXJnaW46MGluIDBpbiAwLjAwMDFw dCAwaW4iPklOU0VSVCBJTlRPIHRhc2tfaGlzdG9yeSAodGFza19pZCwgdXNlcl9pZCwgdGFza19k YXRlKTwvcD48cCBzdHlsZT0iZm9udC1mYW1pbHk6J2NhbGlicmknICwgc2Fucy1zZXJpZjtmb250 LXNpemU6MTFwdDttYXJnaW46MGluIDBpbiAwLjAwMDFwdCAwaW4iPlNFTEVDVCB0YXNrX2lkLCB1 c2VyX2lkLCB0YXNrX2RhdGU8L3A+PHAgc3R5bGU9ImZvbnQtZmFtaWx5OidjYWxpYnJpJyAsIHNh bnMtc2VyaWY7Zm9udC1zaXplOjExcHQ7bWFyZ2luOjBpbiAwaW4gMC4wMDAxcHQgMGluIj5GUk9N IDxlbT48c3Ryb25nPm9ubHk8L3N0cm9uZz48L2VtPiB0YXNrPC9wPjxwIHN0eWxlPSJmb250LWZh bWlseTonY2FsaWJyaScgLCBzYW5zLXNlcmlmO2ZvbnQtc2l6ZToxMXB0O21hcmdpbjowaW4gMGlu IDAuMDAwMXB0IDBpbiI+V0hFUkUgdGFza19pZCBJTiAoMSwgMiwgMyk7PC9wPjwvZGl2PjxkaXY+ QmVzdCByZWdhcmRzLjwvZGl2PjxkaXY+U2FtZWQgWUlMRElSSU08L2Rpdj48ZGl2PsKgPC9kaXY+ PGRpdj7CoDwvZGl2PjxkaXY+wqA8L2Rpdj48ZGl2PjAxLjA0LjIwMjAsIDE2OjQ5LCAiSGVpbmVt YW5uLCBNYW5mcmVkIChJTVMpIiAmbHQ7aGVpbmVtYW5ubUBpbXN3ZWIuY29tJmd0Ozo8L2Rpdj48 YmxvY2txdW90ZT48ZGl2IGxhbmc9IkVOLVVTIj48ZGl2PjxwIHN0eWxlPSJmb250LWZhbWlseTon Y2FsaWJyaScgLCBzYW5zLXNlcmlmO2ZvbnQtc2l6ZToxMXB0O21hcmdpbjowaW4gMGluIDAuMDAw MXB0IDBpbiI+Q2FuIHNvbWV0aGluZyBleHBsYWluIHdoeSBzb21ldGhpbmcgbGlrZSB0aGUgZm9s bG93aW5nIGNvdWxkIGhhcHBlbj88L3A+PHAgc3R5bGU9ImZvbnQtZmFtaWx5OidjYWxpYnJpJyAs IHNhbnMtc2VyaWY7Zm9udC1zaXplOjExcHQ7bWFyZ2luOjBpbiAwaW4gMC4wMDAxcHQgMGluIj7C oDwvcD48cCBzdHlsZT0iZm9udC1mYW1pbHk6J2NhbGlicmknICwgc2Fucy1zZXJpZjtmb250LXNp emU6MTFwdDttYXJnaW46MGluIDBpbiAwLjAwMDFwdCAwaW4iPklOU0VSVCBJTlRPIHRhc2tfaGlz dG9yeSAodGFza19pZCwgdXNlcl9pZCwgdGFza19kYXRlKTwvcD48cCBzdHlsZT0iZm9udC1mYW1p bHk6J2NhbGlicmknICwgc2Fucy1zZXJpZjtmb250LXNpemU6MTFwdDttYXJnaW46MGluIDBpbiAw LjAwMDFwdCAwaW4iPlNFTEVDVCB0YXNrX2lkLCB1c2VyX2lkLCB0YXNrX2RhdGU8L3A+PHAgc3R5 bGU9ImZvbnQtZmFtaWx5OidjYWxpYnJpJyAsIHNhbnMtc2VyaWY7Zm9udC1zaXplOjExcHQ7bWFy Z2luOjBpbiAwaW4gMC4wMDAxcHQgMGluIj5GUk9NIHRhc2s8L3A+PHAgc3R5bGU9ImZvbnQtZmFt aWx5OidjYWxpYnJpJyAsIHNhbnMtc2VyaWY7Zm9udC1zaXplOjExcHQ7bWFyZ2luOjBpbiAwaW4g MC4wMDAxcHQgMGluIj5XSEVSRSB0YXNrX2lkIElOICgxLCAyLCAzKTs8L3A+PHAgc3R5bGU9ImZv bnQtZmFtaWx5OidjYWxpYnJpJyAsIHNhbnMtc2VyaWY7Zm9udC1zaXplOjExcHQ7bWFyZ2luOjBp biAwaW4gMC4wMDAxcHQgMGluIj7CoDwvcD48cCBzdHlsZT0iZm9udC1mYW1pbHk6J2NhbGlicmkn ICwgc2Fucy1zZXJpZjtmb250LXNpemU6MTFwdDttYXJnaW46MGluIDBpbiAwLjAwMDFwdCAwaW4i PkVSUk9SOiBpbnNlcnQgb3IgdXBkYXRlIG9uIHRhYmxlICJ0YXNrX2hpc3RvcnkiIHZpb2xhdGVz IGZvcmVpZ24ga2V5IGNvbnN0cmFpbnQgImZrX3Rhc2tfaGlzdG9yeV90YXNrX2lkIjwvcD48cCBz dHlsZT0iZm9udC1mYW1pbHk6J2NhbGlicmknICwgc2Fucy1zZXJpZjtmb250LXNpemU6MTFwdDtt YXJnaW46MGluIDBpbiAwLjAwMDFwdCAwaW4iPsKgIERldGFpbDogS2V5ICh0YXNrX2lkKT0oMSkg aXMgbm90IHByZXNlbnQgaW4gdGFibGUgInRhc2siLjwvcD48cCBzdHlsZT0iZm9udC1mYW1pbHk6 J2NhbGlicmknICwgc2Fucy1zZXJpZjtmb250LXNpemU6MTFwdDttYXJnaW46MGluIDBpbiAwLjAw MDFwdCAwaW4iPsKgPC9wPjxwIHN0eWxlPSJmb250LWZhbWlseTonY2FsaWJyaScgLCBzYW5zLXNl cmlmO2ZvbnQtc2l6ZToxMXB0O21hcmdpbjowaW4gMGluIDAuMDAwMXB0IDBpbiI+VGhhbmtzLDwv cD48cCBzdHlsZT0iZm9udC1mYW1pbHk6J2NhbGlicmknICwgc2Fucy1zZXJpZjtmb250LXNpemU6 MTFwdDttYXJnaW46MGluIDBpbiAwLjAwMDFwdCAwaW4iPk1hbmZyZWQ8L3A+PC9kaXY+wqA8aHIg Lz48YnIgLz48Zm9udCBmYWNlPSJBcmlhbCIgc2l6ZT0iMSI+SW5mb3JtYXRpb24gaW4gdGhpcyBl LW1haWwgbWF5IGJlIGNvbmZpZGVudGlhbC4gSXQgaXMgaW50ZW5kZWQgb25seSBmb3IgdGhlIGFk ZHJlc3NlZShzKSBpZGVudGlmaWVkIGFib3ZlLiBJZiB5b3UgYXJlIG5vdCB0aGUgYWRkcmVzc2Vl KHMpLCBvciBhbiBlbXBsb3llZSBvciBhZ2VudCBvZiB0aGUgYWRkcmVzc2VlKHMpLCBwbGVhc2Ug bm90ZSB0aGF0IGFueSBkaXNzZW1pbmF0aW9uLCBkaXN0cmlidXRpb24sIG9yIGNvcHlpbmcgb2Yg dGhpcyBjb21tdW5pY2F0aW9uIGlzIHN0cmljdGx5IHByb2hpYml0ZWQuIElmIHlvdSBoYXZlIHJl Y2VpdmVkIHRoaXMgZS1tYWlsIGluIGVycm9yLCBwbGVhc2Ugbm90aWZ5IHRoZSBzZW5kZXIgb2Yg dGhlIGVycm9yLjwvZm9udD48L2Rpdj48L2Jsb2NrcXVvdGU+