Kris Jurka <[EMAIL PROTECTED]> writes:
> This did not work in 7.4 either, it even gives a much better error message
> than 8.0's "syntax error"
> jurka=# select * from catalog.schem.tab;
> ERROR: cross-database references are not implemented
I'm not sure why 8.0 wasn't handling this properly --
On Mon, 1 Nov 2004, Laferriere, Al wrote:
> ResultSet rs =
> stmt.executeQuery("SELECT \"psdb \".\"public\".\"tt\".\"ans\" FROM
> \"psdb \".\"public\".\"tt\"");
>
> java.sql.SQLException: ERROR: syntax error at end of input
>
>
> Also, there is no problem
The following statements work fine in 7.4
Connection
conn = DriverManager.getConnection("jdbc:postgresql://localhost:5432/psdb","xxx","");
Statement
stmt = conn.createStatement();