From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id A2A4024D9F for ; Fri, 13 Jul 2018 09:53:14 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id xgkwOcvVLLiz for ; Fri, 13 Jul 2018 09:53:14 -0400 (EDT) Received: from smtp47.i.mail.ru (smtp47.i.mail.ru [94.100.177.107]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTPS id 08B7222FF9 for ; Fri, 13 Jul 2018 09:53:13 -0400 (EDT) Content-Type: text/plain; charset=utf-8 Mime-Version: 1.0 (Mac OS X Mail 10.3 \(3273\)) Subject: [tarantool-patches] Re: [PATCH] sql: rfc for foreign keys From: "n.pettik" In-Reply-To: <20180713084647.GA20490@chai> Date: Fri, 13 Jul 2018 16:53:11 +0300 Content-Transfer-Encoding: quoted-printable Message-Id: References: <20180627131133.82680-1-korablev@tarantool.org> <20180713084647.GA20490@chai> Sender: tarantool-patches-bounce@freelists.org Errors-to: tarantool-patches-bounce@freelists.org Reply-To: tarantool-patches@freelists.org List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: tarantool-patches List-subscribe: List-owner: List-post: List-archive: To: tarantool-patches@freelists.org Cc: Konstantin Osipov >> Part of #3271 >> --- >> Branch: = https://github.com/tarantool/tarantool/tree/np/gh-3271-foreign-keys-rfc >> Issue: https://github.com/tarantool/tarantool/issues/3271 >>=20 >=20 > Please check with definition schema in the standard re table > structure for information schema and constraint tables. >=20 > --=20 > Konstantin Osipov, Moscow, Russia, +7 903 626 22 32 > http://tarantool.io - www.twitter.com/kostja_osipov Well, actually I didn=E2=80=99t get well what you mean. If you ask to make _fk_constraint table itself be closer to = REFERENTIAL_CONSTRAINTS from ANSI schema definition.. The best effort I am able to do now - = rename it to _referential_constraints.. See part 11 of 2003 standard: 6.3.3 REFERENTIAL_CONSTRAINTS base table: All parts which we already have in Tarantool are represented in = _fk_constraints. Others such as CONSTRAINT_CATALOG, CONSTRAINT_SCHEMA are omitted. Moreover, it stores fields which are absent in ANSI: is_deferred and = array of links. IDK how to remove them from those space and persist at the same time. If you suggest to implement additional table to represent FK = constraints, then I guess it makes no sense - we don=E2=80=99t have any of schema tables = right now.=