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 1k1P8Q-00088q-OT for pgsql-sql@arkaria.postgresql.org; Fri, 31 Jul 2020 07:07:19 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1k1P8O-0003fM-GJ for pgsql-sql@arkaria.postgresql.org; Fri, 31 Jul 2020 07:07:16 +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 1k1P8O-0003eW-7L for pgsql-sql@lists.postgresql.org; Fri, 31 Jul 2020 07:07:16 +0000 Received: from forward501o.mail.yandex.net ([37.140.190.203]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1k1P8G-0004Yk-99 for pgsql-sql@lists.postgresql.org; Fri, 31 Jul 2020 07:07:13 +0000 Received: from mxback2q.mail.yandex.net (mxback2q.mail.yandex.net [IPv6:2a02:6b8:c0e:40:0:640:9c8c:4946]) by forward501o.mail.yandex.net (Yandex) with ESMTP id 6AB4E1E800FF; Fri, 31 Jul 2020 10:07:06 +0300 (MSK) Received: from localhost (localhost [::1]) by mxback2q.mail.yandex.net (mxback/Yandex) with ESMTP id 2owQCTyWXW-75VqklHs; Fri, 31 Jul 2020 10:07:05 +0300 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=reddoc.net; s=mail; t=1596179225; bh=TtPN/f/j6VedjJCQdGpgXO0vIMtAJ5DL0tUbbywKqBA=; h=References:Date:Message-Id:Subject:In-Reply-To:To:From; b=nHrKJfLYf6L4SUDol+dVFaKLtISndXLPwoLxTEA7CAEuqBKoCFXS67IGvzki7yNAd OLKJo8YO+SNx3CO4NiwxBkEs8/DbYuGHnq8gI3GO0HRYwZizqTL8b3IaKPf4fKby47 4cMPWphfpbiDCwE4U69Tg2Z0dcig3NOGeMX28hN4= Authentication-Results: mxback2q.mail.yandex.net; dkim=pass header.i=@reddoc.net Received: by vla4-6633285669a2.qloud-c.yandex.net with HTTP; Fri, 31 Jul 2020 10:07:05 +0300 From: Samed YILDIRIM To: J Lumby , "pgsql-sql@lists.postgresql.org" In-Reply-To: References: Subject: Re: foreign key referencing inheritance parent MIME-Version: 1.0 X-Mailer: Yamail [ http://yandex.ru ] 5.0 Date: Fri, 31 Jul 2020 10:07:05 +0300 Message-Id: <445311596177376@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 PGRpdj48ZGl2PkhpIEpvaG4sPC9kaXY+PGRpdj7CoDwvZGl2PjxkaXY+UGxlYXNlIGZpbmQgYW5z d2VycyBiZWxvdy48L2Rpdj48L2Rpdj48ZGl2PsKgPC9kaXY+PGRpdj4yMC4wNy4yMDIwLCAxNzo0 NCwgIkogTHVtYnkiICZsdDtqb2hubHVtYnlAaG90bWFpbC5jb20mZ3Q7OjwvZGl2PjxibG9ja3F1 b3RlPjxwPlRoaXMgaGFzIGNvbWUgdXAgYmVmb3JlIGVsc2V3aGVyZSBlLmcuPGJyIC8+PGJyIC8+ PGEgaHJlZj0iaHR0cHM6Ly9zdGFja292ZXJmbG93LmNvbS9xdWVzdGlvbnMvMjYwMzQ3NTIvcG9z dGdyZXNxbC1pbmhlcml0YW5jZS1hbmQtZm9yZWlnbi1rZXktcmVmZXJlbmNpbmctcGFyZW50LXRh YmxlIj5odHRwczovL3N0YWNrb3ZlcmZsb3cuY29tL3F1ZXN0aW9ucy8yNjAzNDc1Mi9wb3N0Z3Jl c3FsLWluaGVyaXRhbmNlLWFuZC1mb3JlaWduLWtleS1yZWZlcmVuY2luZy1wYXJlbnQtdGFibGU8 L2E+PGJyIC8+PGJyIC8+YnV0IEkgZG9uJ3Qgc2VlIGFueSBtZW50aW9uIGluIGFueSBwZyBtYWls aW5nIGxpc3QuPGJyIC8+PGJyIC8+PGJyIC8+cG9zdGdyZXNxbCBwZXJtaXRzIGNyZWF0aW9uIG9m IGEgZm9yZWlnbiBrZXkgcmVmZXJlbmNpbmcgYSB0YWJsZSB3aGljaDxiciAvPmlzIHRoZSBwYXJl bnQgb2YgY2hpbGQgdGFibGVzIHZpYSBpbmhlcml0YW5jZTxiciAvPjxiciAvPmJ1dCBlbmZvcmNl cyB0aGF0IGV2ZXJ5IGZvcmVpZ24ga2V5IHZhbHVlIG11c3QgZXhpc3QgYXMgcGtleSBPTkxZIGlu IHRoZTxiciAvPnBhcmVudMKgIC3CoCBpdCB0aHJvd3MgYW4gRVJST1Igb3RoZXJ3aXNlLCBldmVu IGlmIHRoZSBwa2V5IGV4aXN0cyBpbiBhPGJyIC8+Y2hpbGQgdGFibGUuPC9wPjwvYmxvY2txdW90 ZT48ZGl2PkhhdmluZyBvZiBwcmltYXJ5IGtleSBvbiBjaGlsZCB0YWJsZSB3aXRoIHRoZSBzYW1l IGNvbHVtbnMgZG9lc24ndCBtZWFuIHRoYXQgaXQgZ3VhcmFudGVlcyB1bmlxdWVuZXNzIG9mIGEg cmVjb3JkIGFtb25nIHBhcmVudCBhbmQgY2hpbGQgdGFibGVzLiBFYWNoIHByaW1hcnkga2V5IHBy b3ZpZGVzIHVuaXF1ZW5lc3Mgb2YgcmVjb3JkcyBvbmx5IGluIHRoZSB0YWJsZSBvbiB3aGljaCB0 aGV5IGFyZSBjcmVhdGVkLjwvZGl2PjxibG9ja3F1b3RlPjxwPjxiciAvPlRoaXMgaXMgcHJvYmxl bWF0aWMgKHRvIG1lKSBmb3IgdGhyZWUgc2xpZ2h0bHkgZGlmZmVyZW50IHJlYXNvbnMgOjxiciAv PjxiciAvPjEpwqDCoCBpdCBpcyBzdXJwcmlzaW5nLsKgwqDCoCBUaGUgZXhwZWN0YXRpb24gaXMg dGhhdCBhIHJlZmVyZW5jZSB0bzxiciAvPmFjY2Vzc2luZyByb3cocykgaW4gYSBwYXJlbnQgdGFi bGUgd2lsbCBhbHNvIHNlYXJjaCBhbGwgY2hpbGRyZW4swqDCoCBhczxiciAvPndpdGggU0VMRUNU LMKgIHVubGVzcyB0aGUgT05MWSBrZXl3b3JkIGlzIHNwZWNpZmllZC48YnIgLz48YnIgLz53aGlj aCB0aGVuIGxlYWRzIHRvIC4uLjwvcD48L2Jsb2NrcXVvdGU+PGRpdj48YnIgLz5UaGUgYW5zd2Vy IGFib3ZlIGlzIGFsc28gdmFsaWQgaGVyZSA6KTwvZGl2PjxibG9ja3F1b3RlPjxwPjxiciAvPjxi ciAvPjIpwqDCoMKgIGl0IGlzIGluY29uc2lzdGVudCB3aXRoLMKgIGFuZCBsZXNzIHVzZWZ1bCB0 aGFuLMKgwqDCoCB0aGUgc29tZXdoYXQ8YnIgLz5zaW1pbGFyIENIRUNLIGNsYXVzZSBpbiBhIENS RUFURS9BTFRFUiBUQUJMRSA6PGJyIC8+PGJyIC8+X19fX19fX19fX19fX19fX19fX19fX19fX19f X19fX19fX19fX19fX19fX19fX19fX19fX188YnIgLz48YnIgLz7CoMKgwqDCoMKgwqDCoMKgwqAg Q0hFQ0sgKCBleHByZXNzaW9uICkgWyBOTyBJTkhFUklUIF08YnIgLz48YnIgLz5BIGNvbnN0cmFp bnQgbWFya2VkIHdpdGggTk8gSU5IRVJJVCB3aWxsIG5vdCBwcm9wYWdhdGUgdG8gY2hpbGQgdGFi bGVzLjxiciAvPjxiciAvPl9fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19f X19fX19fX19fX19fPGJyIC8+PGJyIC8+Rm9yIENIRUNLLCDCoCB0aGUgZGVmYXVsdCBpcyBwcm9w YWdhdGlvbiB0byBjaGlsZCB0YWJsZXMgdW5sZXNzPGJyIC8+ZXhwbGljaXRseSBwcmV2ZW50ZWQs wqAgd2hpY2ggaXMgY29uc2lzdGVudCB3aXRoIFNFTEVDVCBhbmQgdGhlIE9OTFk8YnIgLz5xdWFs aWZpZXIuPGJyIC8+PGJyIC8+Rm9yIEZPUkVJR04gS0VZIHRoZXJlIGlzIG5vIG9wdGlvbmFsIHF1 YWxpZmllciB0byBleHByZXNzICJwcm9wYWdhdGlvbiLCoDxiciAvPihpLmUuIHByb3BhZ2F0aW9u IG9mIHRoZSBzZWFyY2ggZm9yIHByaW1hcnkga2V5KSBvciAiT05MWSIgYW5kIHRoZTxiciAvPmJl aGF2aW91ciBpcyBhbHdheXMgIk9OTFkiLjxiciAvPjxiciAvPjxiciAvPjMpwqDCoCBJIGFtIHBy b2JhYmx5IHdyb25nIGJ1dCBhcyBmYXIgYXMgSSBjYW4gdGVsbCB0aGlzIGJlaGF2aW91ciBpcyBu b3Q8YnIgLz5kb2N1bWVudGVkIGFueXdoZXJlLjwvcD48L2Jsb2NrcXVvdGU+PGRpdj48YSBocmVm PSJodHRwczovL3d3dy5wb3N0Z3Jlc3FsLm9yZy9kb2NzLzEyL2RkbC1pbmhlcml0Lmh0bWwjRERM LUlOSEVSSVQtQ0FWRUFUUyI+aHR0cHM6Ly93d3cucG9zdGdyZXNxbC5vcmcvZG9jcy8xMi9kZGwt aW5oZXJpdC5odG1sI0RETC1JTkhFUklULUNBVkVBVFM8L2E+PC9kaXY+PGRpdj48YSBocmVmPSJo dHRwczovL3d3dy5wb3N0Z3Jlc3FsLm9yZy9kb2NzLzEyL2RkbC1wYXJ0aXRpb25pbmcuaHRtbCI+ aHR0cHM6Ly93d3cucG9zdGdyZXNxbC5vcmcvZG9jcy8xMi9kZGwtcGFydGl0aW9uaW5nLmh0bWw8 L2E+IMKgLSBUaXRsZSA1LjExLjMuMy4gQ2F2ZWF0czwvZGl2PjxibG9ja3F1b3RlPjxwPjxiciAv PjxiciAvPldvdWxkIHRoZXJlIGJlIGFueSBpbnRlcmVzdCBpbiBwcm92aWRpbmcgYSBjaG9pY2Us IMKgIGUuZy4gYW4gb3B0aW9uYWzCoCBbPGJyIC8+SU5IRVJJVCBdIG9uIHRoZSBSRUZFUkVOQ0VT IGNsYXVzZSzCoCBpbiBhIGZ1dHVyZSByZWxlYXNlPzwvcD48L2Jsb2NrcXVvdGU+PGRpdj7CoDwv ZGl2PjxkaXY+VGhlIG1vc3QgaW1wb3J0YW50IHBhcnQgaXMgd2h5IHlvdSBuZWVkIHRvIHVzZSBm b3JlaWduIGtleSByZWZlcmVuY2luZyB0byBwYXJlbnQgdGFibGUgb2YgaW5oZXJpdGFuY2UuIERl cGVuZGluZyBvbiB5b3VyIGFuc3dlciwgdGhlcmUgYXJlIG11bHRpcGxlIHNvbHV0aW9uLiBGb3Ig ZXhhbXBsZSwgaWYgdGhlIHJlYXNvbiB3aHkgeW91IG5lZWQgaXQgaXMgdGhhdCB5b3UgdXNlIHRh YmxlIHBhcnRpdGlvbmluZyBpbXBsZW1lbnRlZCBieSB1c2luZyB0cmlnZ2VycyBhbmQgdGFibGUg aW5oZXJpdGFuY2UsIHN1Y2ggYXMgaW4gdGhlIGRvY3VtZW50IGJlbG93WzFdLCB5b3UgY2FuIHN3 aXRjaCBkZWNsYXJhdGl2ZSBwYXJ0aXRpb25pbmcgd2l0aCBQb3N0Z3JlU1FMIDEyLiBQb3N0Z3Jl U1FMIDEyIHN1cHBvcnRzIGZvcmVpZ24ga2V5cyByZWZlcmVuY2luZyB0byBwYXJ0aXRpb25lZCB0 YWJsZXMuIFsyXTwvZGl2PjxkaXY+wqA8L2Rpdj48ZGl2PlsxXTogPGEgaHJlZj0iaHR0cHM6Ly93 d3cucG9zdGdyZXNxbC5vcmcvZG9jcy8xMi9kZGwtcGFydGl0aW9uaW5nLmh0bWwjRERMLVBBUlRJ VElPTklORy1JTVBMRU1FTlRBVElPTi1JTkhFUklUQU5DRSI+aHR0cHM6Ly93d3cucG9zdGdyZXNx bC5vcmcvZG9jcy8xMi9kZGwtcGFydGl0aW9uaW5nLmh0bWwjRERMLVBBUlRJVElPTklORy1JTVBM RU1FTlRBVElPTi1JTkhFUklUQU5DRTwvYT48L2Rpdj48ZGl2PlsyXTogPGEgaHJlZj0iaHR0cHM6 Ly93d3cucG9zdGdyZXNxbC5vcmcvZG9jcy8xMi9zcWwtY3JlYXRldGFibGUuaHRtbCI+aHR0cHM6 Ly93d3cucG9zdGdyZXNxbC5vcmcvZG9jcy8xMi9zcWwtY3JlYXRldGFibGUuaHRtbDwvYT48L2Rp dj48dWw+PGxpPldoZW4gZXN0YWJsaXNoaW5nIGEgdW5pcXVlIGNvbnN0cmFpbnQgZm9yIGEgbXVs dGktbGV2ZWwgcGFydGl0aW9uIGhpZXJhcmNoeSwgYWxsIHRoZSBjb2x1bW5zIGluIHRoZSBwYXJ0 aXRpb24ga2V5IG9mIHRoZSB0YXJnZXQgcGFydGl0aW9uZWQgdGFibGUsIGFzIHdlbGwgYXMgdGhv c2Ugb2YgYWxsIGl0cyBkZXNjZW5kYW50IHBhcnRpdGlvbmVkIHRhYmxlcywgbXVzdCBiZSBpbmNs dWRlZCBpbiB0aGUgY29uc3RyYWludCBkZWZpbml0aW9uLjwvbGk+PGxpPjxjb2RlPlBSSU1BUlkg S0VZPC9jb2RlPiBjb25zdHJhaW50cyBzaGFyZSB0aGUgcmVzdHJpY3Rpb25zIHRoYXQgPGNvZGU+ VU5JUVVFPC9jb2RlPiBjb25zdHJhaW50cyBoYXZlIHdoZW4gcGxhY2VkIG9uIHBhcnRpdGlvbmVk IHRhYmxlcy48L2xpPjwvdWw+PGRpdj5JZiB0YWJsZSBwYXJ0aXRpb25pbmcgaXMgbm90IHRoZSBy ZWFzb24sIHRoZSBtb3N0IGdlbmVyYWxpemVkIHNvbHV0aW9uIGNhbiBiZSB0byB1c2UgY29uc3Ry YWludCB0cmlnZ2Vyc1szXSByYXRoZXIgdGhhbiBmb3JlaWduIGtleXMuIEFuZCB5b3UgY2FuIGd1 YXJhbnRlZSB1bmlxdWVuZXNzIG9mIHJlY29yZHMgYW1vbmcgcGFyZW50IGFuZCBjaGlsZCB0YWJs ZXMgYnkgdXNpbmcgY2hlY2sgY29uc3RyYWludHMgYW5kIHByaW1hcnkga2V5L3VuaXF1ZSBrZXkg Y29uc3RyYWludHMgdG9nZXRoZXIuPC9kaXY+PGRpdj7CoDwvZGl2PjxkaXY+WzNdOiA8YSBocmVm PSJodHRwczovL3d3dy5wb3N0Z3Jlc3FsLm9yZy9kb2NzLzEyL3NxbC1jcmVhdGV0cmlnZ2VyLmh0 bWwiPmh0dHBzOi8vd3d3LnBvc3RncmVzcWwub3JnL2RvY3MvMTIvc3FsLWNyZWF0ZXRyaWdnZXIu aHRtbDwvYT48L2Rpdj48ZGl2PsKgPC9kaXY+PGJsb2NrcXVvdGU+PHA+PGJyIC8+Q2hlZXJzLMKg IEpvaG48YnIgLz48YnIgLz7CoDwvcD48L2Jsb2NrcXVvdGU+PGRpdj5CZXN0IHJlZ2FyZHMuPC9k aXY+PGRpdj5TYW1lZCBZSUxESVJJTTwvZGl2Pg==