"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 "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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
