"Gregory S. Williamson" <gsw@xxxxxxxxxxxxxxxx> writes: > As the sequence below shows, I dropped the FK constraint successfully, but when I run TRUNCATE collections_l it says: > ERROR: cannot truncate a table referenced in a foreign key constraint > DETAIL: Table "client_collect_rates" references "collections_l" via foreign key constraint "$2". Hm, works for me. Is it possible that you've got multiple client_collect_rates tables in different schemas, and it's complaining about some other one? The error message doesn't show the schema of the table ... regards, tom lane
