[SQL] PostgreSQL 7.3.1 multiple schema select query error: java.sql.SQLException: ERROR: parser: parse error at or near "."

2003-02-07 Thread waimeng
I am using postgresql 7.3.1 on windows 2000. I downloaded the lattest postgres jdbc driverfor version 7.3.1, called pg73jdbc3.jar and using JBoss-3.04_Tomcat-4.0.6.   I created one database called 'testdb', and a scheme called 'sc_test', with a table called 'tbl_company' under the sc_test sc

[SQL] PostgreSQL 7.3.1 multiple schema select query error: java.sql.SQLException: ERROR: parser: parse error at or near "."

2003-02-07 Thread waimeng
I am using postgresql 7.3.1 on windows 2000. I downloaded the lattest postgres jdbc driver for version 7.3.1, called pg73jdbc3.jar and using JBoss-3.04_Tomcat-4.0.6. I created one database called 'testdb', and a scheme called 'sc_test', with a table called 'tbl_company' under the sc_test scheme.