• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

DB can not find the true relation

 
mostafa jamareh
Greenhorn
Posts: 7
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator


I have a two postgres DB (e.g: DB one & DB two)

in the both of them i have the same relation ,the problem is that when i want to use relation on DB two it store the data on relation of DB one (the DB_URL refers to DB two) so i tried to delete the relation on DB one to see what is going on ,after running again it told me that
ERROR: relation "table" does not exist


i checked my DB_URL and also tried



but does not work

please help me to resolve this problem

thanks in advanse,
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 34839
369
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Is your table named "table"? If so, that is a keyword and could cause problems.

Check what schema the table is in and use that in the drop statement. (And show the drop statement.)
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic