: [GENERAL] Truncate and Foreign Key Constraint question
"Gregory S. Williamson" <[EMAIL PROTECTED]> 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
"Gregory S. Williamson" <[EMAIL PROTECTED]> 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
This is in postgres 8.1:
PostgreSQL 8.1.1 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 3.4.2
20041017 (Red Hat 3.4.2-6.fc3)
I've got a table in one schema (work.client_collect_rates) which has an FK
constraint with a table, content.collections_l (definitions shown below).
There's a
