Re: [GENERAL] can't delete because of constraint from zombie table

2006-11-17 Thread Tom Lane
Jaime Silvela <[EMAIL PROTECTED]> writes: > I do > delete from staging_deal where staging_deal_id = 1 > and get > ERROR: update or delete on "staging_deal" violates foreign key > constraint "staging_deal_fkey" on "staging_document" > DETAIL: Key (staging_deal_id)=(1) is still referenced from tab

[GENERAL] can't delete because of constraint from zombie table

2006-11-17 Thread Jaime Silvela
I'm finding a strange sort of 'zombie' table behavior. I try to delete a row of a database that used to be referenced by a table that has now been deleted. I do delete from staging_deal where staging_deal_id = 1 and get ERROR: update or delete on "staging_deal" violates foreign key constraint