Dimitrios Apostolou <jimis@xxxxxxx> writes: > 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 > TRIGGERS are disabled in all tables. IIRC, it will let you do it if you truncate both the referenced and referencing tables in the same command. The state of the triggers is not material to this, since TRUNCATE doesn't fire them anyway. regards, tom lane
