Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1ih53X-0001d1-RO for pgsql-admin@arkaria.postgresql.org; Tue, 17 Dec 2019 05:05:59 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1ih53W-0003tU-2B for pgsql-admin@arkaria.postgresql.org; Tue, 17 Dec 2019 05:05:58 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1ih53V-0003tN-Kv for pgsql-admin@lists.postgresql.org; Tue, 17 Dec 2019 05:05:57 +0000 Received: from n3.nabble.com ([162.255.23.22]) by makus.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ih53O-0000zO-Ox for pgsql-admin@postgresql.org; Tue, 17 Dec 2019 05:05:56 +0000 Received: from n3.nabble.com (localhost [127.0.0.1]) by n3.nabble.com (Postfix) with ESMTP id 8126C197D4679 for ; Mon, 16 Dec 2019 22:05:49 -0700 (MST) Date: Mon, 16 Dec 2019 22:05:49 -0700 (MST) From: pratmeht To: pgsql-admin@postgresql.org Message-ID: <1576559149526-0.post@n3.nabble.com> Subject: Dependent Objects on Table MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Hi Postgres Admin Community, As we know, when a table is dropped, some dependent objects like views, MVs, functions etc gets dropped. Since there are N number of object types, is there a way to find out which all object types gets dropped on table drop ? I searched online and in official documentation however unable to get this information. Not sure if I may have missed it. Can anyone please help on how to get this info ? Regards, Pratik Mehta -- Sent from: https://www.postgresql-archive.org/PostgreSQL-admin-f2076596.html