Jaime Silvela <JSilvela(at)Bear(dot)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