Re: Truncate and Foreign Key Constraint question

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:tgl(at)sss(dot)pgh(dot)pa(dot)us]
Sent: Wed 4/12/2006 10:02 PM
To: Gregory S. Williamson
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] Truncate and Foreign Key Constraint question

"Gregory S. Williamson" <gsw(at)globexplorer(dot)com> 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!