Thread

1. PostgreSQL JDBC 42.7.5 returns an unexpected catalog name

   Vinhson Nguyen <vinhson.nguyen@ca.ibm.com> — 2025-03-28T18:24:22Z

   1) Problem Description:  
   When upgrading our application to a new PostgreSQL JDBC driver 42.7.5 (from 42.7.4), we got an expected catalog name in the result set returned by DatabaseMetadata.getSchemas().
   
   Expected catalog name:  null (42.7.4) 
   Unexpected catalog name:  dbcert (42.7.5)
   
   2) Connection Info:
   URL used:
   jdbc:postgresql://cteds721.fyre.ibm.com:54172/dbcert
   
   Driver name/Version:
   org.postgresql.Driver/postgresql-42.7.5.jar
   
   userID/pw: dbcert1/***********
   
   3) Attachements:
   a) PG_JDBC_42_7_4.PNG:  Screenshot showing an expected catalog name (null) with driver version 42.7.4.
   b) PG_JDBC_42_7_5.PNG:  Screenshot showing an unexpected catalog name (dbcert) with driver version 42.7.5.
   c) ImportTest.java:  Java test program used in (a) and (b).
   
   If you need any additional details, please let me know.
   
   Thank you in advance!
   Vinhson Nguyen
   
   
   

2. Fwd: PostgreSQL JDBC 42.7.5 returns an unexpected catalog name

   Laurenz Albe <laurenz.albe@cybertec.at> — 2025-03-29T16:21:09Z

   I think this belongs here.
   
   -------- Forwarded Message --------
   From: Vinhson Nguyen <Vinhson.Nguyen@ca.ibm.com>
   To: pgsql-bugs@lists.postgresql.org <pgsql-bugs@lists.postgresql.org>
   Cc: ca_data_access_external@wwpdl.vnet.ibm.com <ca_data_access_external@wwpdl.vnet.ibm.com>
   
   1) Problem Description:  
   When upgrading our application to a new PostgreSQL JDBC driver 42.7.5 (from 42.7.4), we got an expected catalog name in the result set returned by DatabaseMetadata.getSchemas().
   
   Expected catalog name:  null (42.7.4) 
   Unexpected catalog name:  dbcert (42.7.5)
   
   2) Connection Info:
   URL used:
   jdbc:postgresql://cteds721.fyre.ibm.com:54172/dbcert
   
   Driver name/Version:
   org.postgresql.Driver/postgresql-42.7.5.jar
   
   userID/pw: dbcert1/***********
   
   3) Attachements:
   a) PG_JDBC_42_7_4.PNG:  Screenshot showing an expected catalog name (null) with driver version 42.7.4.
   b) PG_JDBC_42_7_5.PNG:  Screenshot showing an unexpected catalog name (dbcert) with driver version 42.7.5.
   c) ImportTest.java:  Java test program used in (a) and (b).
   
   If you need any additional details, please let me know.
   
   Thank you in advance!
   Vinhson Nguyen
   

3. Re: PostgreSQL JDBC 42.7.5 returns an unexpected catalog name

   Andrew Dunstan <andrew@dunslane.net> — 2025-03-29T18:53:53Z

   On 2025-03-28 Fr 2:24 PM, Vinhson Nguyen wrote:
   > 1) Problem Description:
   > When upgrading our application to a new PostgreSQL JDBC driver 42.7.5 (from 42.7.4), we got an expected catalog name in the result set returned by DatabaseMetadata.getSchemas().
   >
   > Expected catalog name:  null (42.7.4)
   > Unexpected catalog name:  dbcert (42.7.5)
   >
   > 2) Connection Info:
   > URL used:
   > jdbc:postgresql://cteds721.fyre.ibm.com:54172/dbcert
   >
   > Driver name/Version:
   > org.postgresql.Driver/postgresql-42.7.5.jar
   >
   > userID/pw: dbcert1/***********
   >
   > 3) Attachements:
   > a) PG_JDBC_42_7_4.PNG:  Screenshot showing an expected catalog name (null) with driver version 42.7.4.
   > b) PG_JDBC_42_7_5.PNG:  Screenshot showing an unexpected catalog name (dbcert) with driver version 42.7.5.
   > c) ImportTest.java:  Java test program used in (a) and (b).
   >
   > If you need any additional details, please let me know.
   
   
   You should probably raise this here: 
   <https://github.com/pgjdbc/pgjdbc/issues>
   
   
   cheers
   
   
   andrew
   
   --
   Andrew Dunstan
   EDB: https://www.enterprisedb.com