Cannot truncate a table which is being referenced by other table

[julian]

Originally posted by jmodic
No need to drop the foreign key constraint. Just disabling it for the duration of truncate operation and enabling it afterwards will be enough. So in your case:

ALTER TABLE t2 DISABLE CONSTRAINT fk2;

TRUNCATE TABLE t1 REUSE STORAGE;  

ALTER TABLE t2 ENABLE CONSTRAINT fk2;

Yes, that's the way it should be done...