Using the JDBC interface to inspect the metadata in a table, the ResultSet returned from using DatabaseMetaData.getImportedKeys includes values for KEY_SEQ. This is an integer value and in the case of Postgreql starts at zero.
I can find no formal definition of where this value should start but the ODBC rules explicitly state that it should start at 1 and both DB/2 and MySQL seem to agree. To fix this line 2437 of jdbc2/DatabaseMetaData.java needs to be changed from:- short seq = 0; to:- short seq = 1; The same change is required in jdbc1/DatabaseMetaData.java. ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
