aspose file tools*
The moose likes JDBC and the fly likes DB can not find the true relation Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "DB can not find the true relation" Watch "DB can not find the true relation" New topic

DB can not find the true relation

mostafa jamareh

Joined: Jan 20, 2014
Posts: 7

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

Joined: May 26, 2003
Posts: 31067

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.)

[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
I agree. Here's the link:
subject: DB can not find the true relation