Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • 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: 34095
337
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.)
 
Don't get me started about those stupid light bulbs.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic