• 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
Sheriff
Posts: 36031
432
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.)
 
Gravity is a harsh mistress. But this tiny ad is pretty easy to deal with:
the new thread boost feature: great for the advertiser and smooth for the coderanch user
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!