Re: [BUGS] 8.0 beta4: Exception when including catalog qualifier in

2004-11-07 Thread Tom Lane
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 --

Re: [BUGS] 8.0 beta4: Exception when including catalog qualifier in

2004-11-07 Thread Kris Jurka
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

Re: [BUGS] 8.0 beta4: Exception when including catalog qualifier in SELECT from

2004-11-07 Thread Laferriere, Al
The following statements work fine in 7.4       Connection conn = DriverManager.getConnection("jdbc:postgresql://localhost:5432/psdb","xxx","");     Statement stmt = conn.createStatement();