Re: can't delete because of constraint from zombie table - Mailing list pgsql-general

Jaime Silvela <JSilvela@Bear.com> 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 table
> "staging_document".

> I try to find that table
> select * from staging_document
> but
> ERROR:  relation "staging_document" does not exist

Sounds to me like "staging_document" is in a schema that is not in your
search path?

            regards, tom lane