Doh ! A test schema that was a left over. Thanks for the sanity check ... as usual, pilot error!
g -----Original Message----- From: Tom Lane [mailto:[EMAIL PROTECTED] Sent: Wed 4/12/2006 10:02 PM To: Gregory S. Williamson Cc: pgsql-general@postgresql.org Subject: Re: [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 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 !DSPAM:443ddb4b66027357040552! ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
