Re: [SQL] PostgreSQL 7.3.1 multiple schema select query error:

On Fri, 7 Feb 2003, waimeng wrote: The Exception is thrown in public java.sql.ResultSet execute() method of QueryExecutor.java This method implements the native protocol of postgres server/client communication. So, the message is actually from the backend. See line 104: errorMessage.append(pg_st

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

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.

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

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