Re: 8.0 beta4: Exception when including catalog qualifier in

#1

On Mon, 1 Nov 2004, Laferriere, Al wrote:

Quote:

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 with UPDATE or INSERT statements when the
catalog is included. Only in the SELECT statement.

Doubtful:

jurka=# insert into catalog.schem.tab.col values (1,2,3);
ERROR: improper qualified name (too many dotted names):
catalog.schem.tab.col

Quote:

I did note that the driver does return false to
connection.getMetaData().supportsCatalogsInDataMan ipulation(), so, there
is actually no reason to expect that catalog qualifiers would be
supported. However, as noted, it did work OK in 7.4 (even though the
supportsCatalogsInDataManipulation() returned false there also).

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

Kris Jurka

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

#2

Kris Jurka <books (AT) ejurka (DOT) com> writes:

Quote:

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 --- I suspect that
the hack I used awhile ago to suppress a reduce/reduce conflict was
actually just confusing bison so much it didn't recognize that the
grammar was ambiguous. Anyway, I've fixed it in CVS tip.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: 8.0 beta4: Exception when including catalog qualifier in

comp.databases.postgresql.bugs comp.databases.postgresql.bugs

Re: 8.0 beta4: Exception when including catalog qualifier in - 11-07-2004 , 07:25 PM

Re: 8.0 beta4: Exception when including catalog qualifier in - 11-07-2004 , 10:05 PM