Jaime Silvela <JSilvela@xxxxxxxx> 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
