[BUGS] Bug #589: JDBC KEY_SEQ in getImportedKey starts at 0
David Goodenough ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description JDBC KEY_SEQ in getImportedKey starts at 0 Long Description getImportedKey from DatabaseMetaData returns a ResultSet and in that ResultSet are values with a key KEY_SEQ. In Postgresql this starts at 0, but DB/2 and MySql both start at 1. I can find no document which requires a particular start for JDBC, but the ODBC docs do require this to start at 1. Change is needed to both jdbc2/DatabaseMetaData.java and the jdbc1 version. There is a short seq = 0; which needs to be changed to short seq = 1; Sample Code No file was uploaded with this report ---(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
[BUGS] Bug #590: Migration to Postgres 7.2 impossible when capitals are used in database name
Ruud van den Brink ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description Migration to Postgres 7.2 impossible when capitals are used in database name Long Description Hello, I discovered a bug in the connect statements of postgresql 7.2. After a pg_dumpall in postgresql 7.1.3, upgrading to Postgresql 7.2 and an initdb, the following lines from the script, generated by pg_dumpall, cause a problem: --- \connect template1 postgres CREATE DATABASE "iBBS-oud" WITH TEMPLATE = template0 ENCODING = 'SQL_ASCII'; \connect iBBS-oud postgres --- The database replies with: FATAL 1: Database "ibbs-oud" does not exist in the system catalog. The reason is, that the database is called "iBBS-oud" and not "ibbs-oud". The script contains the correct name of the database, but postgres seems to convert the capitals in "iBBS-oud" to lowercase so it becomes "ibbs-oud" internally. It is however possible to connect to this database by means of starting psql with "psql -U postgres iBBS-oud". Connect statements in postgres itself all fail. But it's impossible to convert a set of huge databases from postgresql 7.1.3 to version 7.2 Kind regards and keep up the good work, Ruud van den Brink. Sample Code No file was uploaded with this report ---(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
Re: [BUGS] Bug #590: Migration to Postgres 7.2 impossible when capitals are used in database name
[EMAIL PROTECTED] writes: > The reason is, that the database is called "iBBS-oud" and not "ibbs-oud". The script >contains the correct name of the database, but postgres seems to convert the capitals >in "iBBS-oud" to lowercase so it becomes "ibbs-oud" internally. Yes, pg_dump fails to quote the database name properly. This is already fixed for 7.2.1. You may care to grab current sources (see the nightly snapshot tarballs in the FTP dev/ directory) and use the latest pg_dump to perform the dump from your 7.1.3 server. Or just edit the connect statements in the dump you have. regards, tom lane ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
