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 A6F2B25607 for ; Fri, 8 Jun 2018 00:08:51 -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 KynPmcO94KRs for ; Fri, 8 Jun 2018 00:08:51 -0400 (EDT) Received: from smtp52.i.mail.ru (smtp52.i.mail.ru [94.100.177.112]) (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 6009C20860 for ; Fri, 8 Jun 2018 00:08:51 -0400 (EDT) Date: Fri, 8 Jun 2018 07:08:48 +0300 From: Konstantin Osipov Subject: [tarantool-patches] Re: [PATCH] sql: rework VIEW internals Message-ID: <20180608040848.GI6866@chai> References: <1528129571.147907906@f369.i.mail.ru> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: 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: Vladislav Shpilevoy * n.pettik [18/06/07 23:59]: > > Generally, you should consult with the data dictionary, not data dictionary cache, when checking object dependency constraints. It's the same problem with sequences, views, triggers, functions, users, roles, privileges, virtually any object in the database. And we implement independent, ad-hoc solutions for each kind of dependency. We simply need a global map object_type, object_id -> object_type, object-id, either as a system space or simply as a standalone hash in the data dictionary cache. -- Konstantin Osipov, Moscow, Russia, +7 903 626 22 32 http://tarantool.io - www.twitter.com/kostja_osipov