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 BC621267DA for ; Thu, 21 Jun 2018 12:06:07 -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 xEs44DMe7kif for ; Thu, 21 Jun 2018 12:06:07 -0400 (EDT) Received: from smtpng3.m.smailru.net (smtpng3.m.smailru.net [94.100.177.149]) (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 7B395267D3 for ; Thu, 21 Jun 2018 12:06:07 -0400 (EDT) Subject: [tarantool-patches] Re: [PATCH v1 2/2] sql: unset pragma in transitive-transactions test References: <247508fef5484e49ff4be8181078533cac8e0cd3.1529510053.git.kshcherbatov@tarantool.org> From: Kirill Shcherbatov Message-ID: Date: Thu, 21 Jun 2018 19:06:04 +0300 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset="utf-8" Content-Language: en-US Content-Transfer-Encoding: 8bit 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: "n.pettik@corp.mail.ru" On 21.06.2018 18:45, n.pettik wrote: > >> +box.sql.execute('PRAGMA defer_foreign_keys = 0;') >> +box.sql.execute('pragma foreign_keys = 0;’); > > Could you please explain, why do you need to turn off foreign keys? > AFAIK by default they are enabled. It is okay to change defer mode, but > I see no reason to disable them at all. Yes, I've already dropped this line on branch. This was an extra diff. I've tried to undone all settings that you apply. Disable defer_foreign_keys is really enough.