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 1k6icP-0002KK-I4 for pgsql-admin@arkaria.postgresql.org; Fri, 14 Aug 2020 22:56:13 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1k6icO-0002nu-2U for pgsql-admin@arkaria.postgresql.org; Fri, 14 Aug 2020 22:56:12 +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 1k6icN-0002nm-As for pgsql-admin@lists.postgresql.org; Fri, 14 Aug 2020 22:56:11 +0000 Received: from resqmta-ch2-05v.sys.comcast.net ([2001:558:fe21:29:69:252:207:37]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1k6icF-0007aQ-G2 for pgsql-admin@postgresql.org; Fri, 14 Aug 2020 22:56:10 +0000 Received: from resomta-ch2-01v.sys.comcast.net ([69.252.207.97]) by resqmta-ch2-05v.sys.comcast.net with ESMTP id 6iU4kB7AtkELE6ic8k5fy5; Fri, 14 Aug 2020 22:55:56 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=comcast.net; s=20190202a; t=1597445756; bh=xsVjYyfKr7Vk9H/m/wD9WaMsBkvXMSS/pHlPs4tpr3M=; h=Received:Received:Received:From:To:Subject:Date:Message-ID: MIME-Version:Content-Type; b=5Qjzyl3vChxLYGJTuBTPLzheD9qCqSyiRd9t6GQkSEEj5X4ki0cXifre2/adEWh6T v8+mJgZsehlPhKGf4urLge2/VTEQEIWUzfjj9Csukm1QW8VaYIji0dA0/njbcxQYQO l0i6a9GtoSNUXhVxnflDVn0I5ks82t5pv8mW8k8d9/vG2t3SRmznMovrv+BdPd7Vdb EX4gsQO5RVxAx99FJcqL4Ub95sD1VyaJPTc/UwSW/4ZVZ9SGJOKKOWuCHwnt638mie 6ykAZazThr1VMcoxBX4Ulz2eWvbxF+V8wjHtoQWJ3+ShpzhOr0IjGfunCQ2do6vdDt D7Gfbc1LtzbrA== Received: from jsievers.comcast.net ([12.187.116.132]) by resomta-ch2-01v.sys.comcast.net with ESMTPA id 6ibdk7AiIhXo46ibzkVQjc; Fri, 14 Aug 2020 22:55:54 +0000 X-Xfinity-VAAS: gggruggvucftvghtrhhoucdtuddrgeduiedrleekgddujecutefuodetggdotefrodftvfcurfhrohhfihhlvgemucevohhmtggrshhtqdftvghsihdpqfgfvfdppffquffrtefokffrnecuuegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenucfjughrpefhvffufhffjgfkfgggtgesthdtredttdertdenucfhrhhomheplfgvrhhrhicuufhivghvvghrshcuoehgshhivghvvghrshduleestghomhgtrghsthdrnhgvtheqnecuggftrfgrthhtvghrnhepieejueetieefuedttddtieeiveeugeeiteeuhfeuiefhueelgfeiveduteffvdelnecukfhppeduvddrudekjedrudduiedrudefvdenucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhephhgvlhhopehjshhivghvvghrshdrtghomhgtrghsthdrnhgvthdpihhnvghtpeduvddrudekjedrudduiedrudefvddpmhgrihhlfhhrohhmpehgshhivghvvghrshduleestghomhgtrghsthdrnhgvthdprhgtphhtthhopeifvghllhhsrdholhhivhgvrhesghhmrghilhdrtghomhdprhgtphhtthhopehpghhsqhhlqdgrughmihhnsehpohhsthhgrhgvshhqlhdrohhrgh X-Xfinity-VMeta: sc=-100.00;st=legit Received: from jsievers.enova.com (localhost [127.0.0.1]) by jsievers.comcast.net (Postfix) with ESMTP id 2417026005A; Fri, 14 Aug 2020 17:55:25 -0500 (CDT) From: Jerry Sievers To: Wells Oliver Cc: pgsql-admin Subject: Re: Seeing where a given trigger function is in use? References: Date: Fri, 14 Aug 2020 17:55:25 -0500 In-Reply-To: (Wells Oliver's message of "Fri, 14 Aug 2020 15:21:27 -0700") Message-ID: <87o8ncalcy.fsf@jsievers.enova.com> User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/25.1 (gnu/linux) MIME-Version: 1.0 Content-Type: text/plain List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Wells Oliver writes: > Trying to track down every table that is using a certain trigger > function, what's the best way to do that? Have a look at the fields tgrelid and tgfoid in your pg_trigger catalog where you will be enlightened :-) For starters... select tgrelid::regclass, tgfoid::regproc from pg_trigger; Enjoy! > > -- > Wells Oliver > wells.oliver@gmail.com > > -- Jerry Sievers Postgres DBA/Development Consulting e: postgres.consulting@comcast.net