Working on PostGreSQL and have ever encountered the error
(0A000/0) ERROR: cross-database references are not implemented: ?
Then your search ends here and I hope this blog would answer your queries
PostGreSQL Database/Catalog/Schema/Table names are case sensitive. If the name contains any upper case letter, they have to be encapsulated between double quotes. If not, the Database/Catalog/Schema/Table names in query is internally converted to small case during execution and throws following error
(0A000/0) ERROR: cross-database references are not implemented:
And this behavior is in non-compliance/incompatible with SQL standards
Actually the error could be because of 2 reasons
a) If you are trying to connect to a remote DB
Solution : Use DBLink (The link to DBLink would explain it all)
b) If Database/Catalog/Schema/Table name contains alphabets in upper case and they are not encapsulated within double quotes
Solution : In your query , specify the Database/Catalog/Schema/Table names as “Database”.”Schema”.”Table”
Reference :
From the official website of PostGreSQL on their syntax
http://www.postgresql.org/docs/8.0/static/sql-syntax.html
Snippet from the above link which explains it
