JDBC Driver Test Suite Drop Table w/ Cascade - Mailing list pgsql-patches

From Kris Jurka
Subject JDBC Driver Test Suite Drop Table w/ Cascade
Date
Msg-id 3D7CECBA.1000309@ejurka.com
Whole thread Raw
List pgsql-patches
The dependency tracking added in 7.3 causes a number of JDBC tests to
fail because drop table commands are issued for tables that cannot be
dropped with the default restrict settings.

Kris Jurka
Index: src/interfaces/jdbc/org/postgresql/test/TestUtil.java
===================================================================
RCS file: /projects/cvsroot/pgsql-server/src/interfaces/jdbc/org/postgresql/test/TestUtil.java,v
retrieving revision 1.1
diff -c -r1.1 TestUtil.java
*** src/interfaces/jdbc/org/postgresql/test/TestUtil.java    2002/08/14 20:35:40    1.1
--- src/interfaces/jdbc/org/postgresql/test/TestUtil.java    2002/09/09 18:38:26
***************
*** 109,115 ****
              Statement stmt = con.createStatement();
              try
              {
!                 stmt.executeUpdate("DROP TABLE " + table);
              }
              catch (SQLException ex)
              {
--- 109,119 ----
              Statement stmt = con.createStatement();
              try
              {
!                 String sql = "DROP TABLE " + table;
!                 if (((org.postgresql.jdbc1.AbstractJdbc1Connection)con).haveMinimumServerVersion("7.3")) {
!                     sql += " CASCADE ";
!                 }
!                 stmt.executeUpdate(sql);
              }
              catch (SQLException ex)
              {

pgsql-patches by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: cube and earthdistance diffs
Next
From: "Arturo Josè Montes Sinning"
Date:
Subject: Re: Patch to support ordering of tid