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 1p3OZM-0000Jd-7J for pgsql-admin@arkaria.postgresql.org; Thu, 08 Dec 2022 21:36:40 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1p3OZK-0007GD-TK for pgsql-admin@arkaria.postgresql.org; Thu, 08 Dec 2022 21:36:38 +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 1p3OZJ-0007G4-2H for pgsql-admin@lists.postgresql.org; Thu, 08 Dec 2022 21:36:38 +0000 Received: from out1-smtp.messagingengine.com ([66.111.4.25]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1p3OZE-0005fd-Jc for pgsql-admin@lists.postgresql.org; Thu, 08 Dec 2022 21:36:36 +0000 Received: from compute3.internal (compute3.nyi.internal [10.202.2.43]) by mailout.nyi.internal (Postfix) with ESMTP id 2385B5C00BD; Thu, 8 Dec 2022 16:36:30 -0500 (EST) Received: from mailfrontend1 ([10.202.2.162]) by compute3.internal (MEProxy); Thu, 08 Dec 2022 16:36:30 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= quadratum-braccas.com; h=cc:content-transfer-encoding :content-type:date:date:from:from:in-reply-to:message-id :mime-version:reply-to:sender:subject:subject:to:to; s=fm2; t= 1670535390; x=1670621790; bh=jsOClhIEqMpkyOxnGHweSG47SeVgAHVMXOw YBZyxuE4=; b=0T4dhh6UJ3y93miDFV/u4M9VPH9MjS/5kPSZ4UT1PErT+PGKrup 7LNGWnB7SVVNCNncUUY0vXBEkNy4uLgDLai6COzkwoEUyo5Y9X5zqIkAtAxAPKTw BOqbsWgx9KHAClzaICZbCl4dw7wW+QIknl9RYRxzEczDuAX+W5dQSPare/58COo7 m962iKTYYsAs+I9Jzeczec+7SsUDg0lKoAvN4dTW7fAlfGjSMWvzphVOIxhViB27 ABbGaLGfHMBluL9VnQkvX/REqEDU+lalwSRt2tQAD1UxbJ0BCk3Ash/beUW6M+lb r4/g3xy9nr9tWDHh5vXKRbr/mgZIdu9pITg== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-transfer-encoding:content-type :date:date:feedback-id:feedback-id:from:from:in-reply-to :message-id:mime-version:reply-to:sender:subject:subject:to:to :x-me-proxy:x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s= fm2; t=1670535390; x=1670621790; bh=jsOClhIEqMpkyOxnGHweSG47SeVg AHVMXOwYBZyxuE4=; b=RmfYIM5Cz60uXqIFjztQRg9Y9t+ol+LnkvTvDlxK7ttH cqTbDsjPunoRoe6lAk9lG2QwXgaP2cGBhw72FiZQRfZPNJ7ErgkUdAYOEtyWN8pO 5aeh0bWn+uYfm6VTwzQHGMO/lI3/HrFkUbZH2AEbDz6Qaxp5HLgACXdtjRAq4pDr GfzmpwXi83dbVWc1mSjIksZ5Kfbh8E12iuuVURyDx6BKwvodAWTqk8di2XrCASlc 7wtC5CuSHP2ARRtgRfgtvVnG56+N6SNUJJ5pe9Yp77utyw3dhsotX80+NPKzXhzr hyPhq8l2hfja7Jgc59SHceyIbWzVfLYkFe9Emf1k8w== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvhedrvddtgdduheefucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucenucfjughrpefkffggfgfvhffutgfgsehtjeertd dtfeejnecuhfhrohhmpefusghosgcuoehssghosgesqhhurggurhgrthhumhdqsghrrggt tggrshdrtghomheqnecuggftrfgrthhtvghrnhepgedvheehudevtdeujeekgfefheetud ffgfetjeeftdejgfdttdegtdejheeiuddunecuvehluhhsthgvrhfuihiivgeptdenucfr rghrrghmpehmrghilhhfrhhomhepshgsohgssehquhgrughrrghtuhhmqdgsrhgrtggtrg hsrdgtohhm X-ME-Proxy: Feedback-ID: i374947ac:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Thu, 8 Dec 2022 16:36:29 -0500 (EST) Message-ID: <134db88e-0735-1e96-cd94-3ee5bbaf8fac@quadratum-braccas.com> Date: Thu, 8 Dec 2022 14:36:27 -0700 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.5.1 To: Pgsql-admin Content-Language: en-US From: Sbob Subject: PostgreSQL Constraints and Foreign Keys - Dropping Tables Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk I just saw a post indicating that PostgreSQL Foreign Keys and Constraints are actually managed via triggers, therefore instead of doing a DROP TABLE CASCADE I could just disable triggers. Is this true? If so it 'feels' like there may be dangerous side effects, any thoughts on any cautions and gotcha's to this approach? Thanks in advance