Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1u4HV1-0005ud-HK for pgsql-general@arkaria.postgresql.org; Mon, 14 Apr 2025 10:57:12 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1u4HUz-00H3Za-7x for pgsql-general@arkaria.postgresql.org; Mon, 14 Apr 2025 10:57:10 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1u4HUy-00H3ZR-R6 for pgsql-general@lists.postgresql.org; Mon, 14 Apr 2025 10:57:09 +0000 Received: from mout.gmx.net ([212.227.17.20]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1u4HUx-0000Tp-0Y for pgsql-general@lists.postgresql.org; Mon, 14 Apr 2025 10:57:08 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmx.net; s=s31663417; t=1744628225; x=1745233025; i=jimis@gmx.net; bh=EJNxX/n3YlEDP3aCyMBbjVD237VDGMHrQZfq5jox5ac=; h=X-UI-Sender-Class:Date:From:To:Subject:Message-ID:MIME-Version: Content-Type:Content-Transfer-Encoding:cc: content-transfer-encoding:content-type:date:from:message-id: mime-version:reply-to:subject:to; b=Y5auhSjP+wXPxl3qrDuWMBB3mqiu9dcQ4/s/QbPWm1YKMNqm+Zm6zzHxyIeyLNUA hdfRqKwkggvhQMXT6EDCMNUUm0vZPZIoahnXDmWryUvGOx+2z2pdly1iYv0AbXnoM 1vdpEh+1tl6EMLcyDeN1ZmbzspiKc3fDjq2r4125nLn332+qDuxRZW/CuQ5231rpX vqlYTWATt5U9rU6xRgF4dR2QvSr0EBnoGIGYi6ObCbzYlvOBzaFsFRTdlNmbfe8wA JD3cYYOU5pYMp+V7V09RraE4KYWcNNPDtev0bTwKWPxT3xi6TeAD0M80B00cWyHvN nLlPVdl7sCFTPhh9vg== X-UI-Sender-Class: 724b4f7f-cbec-4199-ad4e-598c01a50d3a Received: from [10.9.70.81] ([185.55.106.54]) by mail.gmx.net (mrgmx105 [212.227.17.168]) with ESMTPSA (Nemesis) id 1MbivG-1tSBrT0nS2-00b1Gg for ; Mon, 14 Apr 2025 12:57:05 +0200 Date: Mon, 14 Apr 2025 12:57:04 +0200 (CEST) From: Dimitrios Apostolou To: pgsql-general@lists.postgresql.org Subject: TRUNCATE ONLY with foreign keys and triggers disabled Message-ID: MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset=US-ASCII X-Provags-ID: V03:K1:ALZ3teVP5N+ptdjGltjhT+WKdoi9O2ybgTaz3sFErkJZC6UOVfe ggebIYXd9odWmAAXJTwL2acxtM7O+ma0bnWae+jXaNRK5+nz+lU7KY2MEhifxstXEAgVCon wZTlITvHGU26Sg/OHlaew9mZgmmuYFK0kp5Erv2HOG9Q8VvYqMxzY8ALjLlQp9EWuC3K7+c 0q33DXwCMQ0n9CIA8lbdw== X-Spam-Flag: NO UI-OutboundReport: notjunk:1;M01:P0:JwXZ/MUFdAU=;jLkxg6bBvxVY/qH0cFLvcnOSDBX 5LEVwbfhMy/Cgi33aiZKQchKdSNFRXdxuUbCC+0233986o9AlQEX8ySCX257YwhZk/ItrYwI9 gochZ+KFGlU90DOc7sUYbN6XDGQEnR3HDzie186AsucJOuKYienTjETpu9YgnOtZBy9fhl9Un MpIVG04XVlPzrAOakdIO7WL8A4QREOmqndH2cpkzUuQZsZc2A/TOKyqb2TZi9ZaN608Y9JHJ6 MuRRDwn/bR1wUyxh7cQxe37uOMr2MEJmE2a5xT0BKOVhVE1Dgm8E1pNuSlqkn7LdTxZb3vJr7 ZhbgdAsVmeFppPHCV5nbvVf7YgEd5M5+El1KdeZijt1q52wLcVaYsJ31/11WsxHkUMYe2ljzY ERuS2iU0PiavYNTdBC7gAA72Qg422m9hFN3T31KnKnx+VifWI1jz82gVPbm0twmDgG0ZlicK7 RZCUj/RYaR9t8uOTFa/RkJGSa4FZOS9S49vrwUm7aDEhsht+J26AUmh6h9RmllakErzyTLocS /anm4MOit2+GuLhDLwgD8ck2YjSyD8Db5O5ri6AxQ4C9EaFObJaoP/op0MbsWTp0NtvaV+kcY RDxZoiG4DY7mDETePdqeCIDjBj150CO0re/fJrHAsgn20Ecl2kErogc+DZV9BcgbnpDgYS1iI qchWkxq3NSUu5bfDCWrCag1XazRz7bEQDhxWbKdzRx+c0cIz/t+64I+csjxfDeKbILzHBPyNB XbHlZBvy/1kHidZxTDVSJatt4NV09Vzzd4mvMil3VZ9oJvWl/7fem6qWG5cyZCRAhBPNg0uLd odDWxtiUs3wcKbKay0dNchoj/SKWtuigHHXTn9Wf3Qh55w7ehheVvgc/QsmnHyfBte+oCqZIu 3tTQXu2zi5Vq0KerUUWfz77D+Pv99cdRNHYTYiVa4Ep8kuadkr+O3w29QIKuq80PkpOT7yAZ+ rxya2h90Oto/bj/A8uqsLfZaWN5haUS1tAjw3QKdwkyhpJol/eZbxOZp/141VkKpJ7RyuUQq6 cPk4oTWXbtsUwmo/nxi2/apTlf62fviKSRQOojZWRzEsoakWPO3FwCHYxTlcUVXkFRF+cv9tW t9AGbl7k8D+fFxyfeYzPyTNbp87GaRr4+O7/R8TGZiOUmpSJuh0SvkizWMPvHTwBF9kCwPsKh j7IjMS9WKGUife25CXC4TcAWfDg8/bt2N1QvH003eAvns5k4MIb3Le3UDHsOFW7vPRXOEaoX0 Nbe5/y1PI9qPOZ6wBwRiWNuyD8GgQeAXAwLZsNWi7r6V8J+Zkohxgazoz5287AmP4WGwW5omb STaDI/J4mDPqMM217TNAaxobBwtg+c7Y0QRQo7hCHNlpxFz4+ivs4Hjo3p5lSJSUPQGK3kPf0 FBQbBoBQ6E5yhnVIntuvFJfVLIgNaZwtuFzbv56qUdfslnIA/LJ50DXEva3iGbXeGpTOM/qjb ScJUKUw== Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hello list, While doing TRUNCATE ONLY I get: ERROR: cannot truncate a table referenced in a foreign key constraint But in my case the table to be truncated is already empty, and the=20 TRIGGERS are disabled in all tables. I wonder, is there a deeper reason for this error, or is it just an=20 implementation shortcoming? In other words, how easy would it be to write= =20 a patch that allows TRUNCATE even with foreign keys when triggers are=20 disabled or the table is empty? Thanks in advance, Dimitris