From 3d21bf82c3e27396bd3598810cbcc6f7cdc05adf Mon Sep 17 00:00:00 2001 From: Peter Mount Date: Tue, 13 Feb 2001 16:39:06 +0000 Subject: Some more including the patch to DatabaseMetaData backed out by Bruce. Tue Feb 13 16:33:00 GMT 2001 peter@retep.org.uk - More TestCases implemented. Refined the test suite api's. - Removed need for SimpleDateFormat in ResultSet.getDate() improving performance. - Rewrote ResultSet.getTime() so that it uses JDK api's better. Tue Feb 13 10:25:00 GMT 2001 peter@retep.org.uk - Added MiscTest to hold reported problems from users. - Fixed PGMoney. - JBuilder4/JDBCExplorer now works with Money fields. Patched Field & ResultSet (lots of methods) for this one. Also changed cash/money to return type DOUBLE not DECIMAL. This broke JBuilder as zero scale BigDecimal's can't have decimal places! - When a Statement is reused, the previous ResultSet is now closed. - Removed deprecated call in ResultSet.getTime() Thu Feb 08 18:53:00 GMT 2001 peter@retep.org.uk - Changed a couple of settings in DatabaseMetaData where 7.1 now supports those features - Implemented the DatabaseMetaData TestCase. Wed Feb 07 18:06:00 GMT 2001 peter@retep.org.uk - Added comment to Connection.isClosed() explaining why we deviate from the JDBC2 specification. - Fixed bug where the Isolation Level is lost while in autocommit mode. - Fixed bug where several calls to getTransactionIsolationLevel() returned the first call's result. --- .../jdbc/org/postgresql/jdbc2/DatabaseMetaData.java | 16 +++++++--------- 1 file changed, 7 insertions(+), 9 deletions(-) (limited to 'src/interfaces/jdbc/org/postgresql/jdbc2/DatabaseMetaData.java') diff --git a/src/interfaces/jdbc/org/postgresql/jdbc2/DatabaseMetaData.java b/src/interfaces/jdbc/org/postgresql/jdbc2/DatabaseMetaData.java index 64435d81bd..c718a3ac5c 100644 --- a/src/interfaces/jdbc/org/postgresql/jdbc2/DatabaseMetaData.java +++ b/src/interfaces/jdbc/org/postgresql/jdbc2/DatabaseMetaData.java @@ -736,7 +736,7 @@ public class DatabaseMetaData implements java.sql.DatabaseMetaData */ public boolean supportsOuterJoins() throws SQLException { - return false; + return true; // yes 7.1 does } /** @@ -748,7 +748,7 @@ public class DatabaseMetaData implements java.sql.DatabaseMetaData */ public boolean supportsFullOuterJoins() throws SQLException { - return false; + return true; // yes in 7.1 } /** @@ -760,7 +760,7 @@ public class DatabaseMetaData implements java.sql.DatabaseMetaData */ public boolean supportsLimitedOuterJoins() throws SQLException { - return false; + return true; // yes in 7.1 } /** @@ -1009,7 +1009,7 @@ public class DatabaseMetaData implements java.sql.DatabaseMetaData */ public boolean supportsUnion() throws SQLException { - return false; + return true; // 7.0? } /** @@ -1617,8 +1617,7 @@ public class DatabaseMetaData implements java.sql.DatabaseMetaData * * *

The valid values for the types parameter are: - * "TABLE", "INDEX", "LARGE OBJECT", "SEQUENCE", "SYSTEM TABLE" and - * "SYSTEM INDEX" + * "TABLE", "INDEX", "SEQUENCE", "SYSTEM TABLE" and "SYSTEM INDEX" * * @param catalog a catalog name; For org.postgresql, this is ignored, and * should be set to null @@ -1722,9 +1721,8 @@ public class DatabaseMetaData implements java.sql.DatabaseMetaData // IMPORTANT: the query must be enclosed in ( ) private static final String getTableTypes[][] = { {"TABLE", "(relkind='r' and relhasrules='f' and relname !~ '^pg_' and relname !~ '^xinv')"}, - {"VIEW", "(relkind='v' and relname !~ '^pg_' and relname !~ '^xinv')"}, - {"INDEX", "(relkind='i' and relname !~ '^pg_' and relname !~ '^xinx')"}, - {"LARGE OBJECT", "(relkind='r' and relname ~ '^xinv')"}, + {"VIEW", "(relkind='v' and relname !~ '^pg_')"}, + {"INDEX", "(relkind='i' and relname !~ '^pg_')"}, {"SEQUENCE", "(relkind='S' and relname !~ '^pg_')"}, {"SYSTEM TABLE", "(relkind='r' and relname ~ '^pg_')"}, {"SYSTEM INDEX", "(relkind='i' and relname ~ '^pg_')"} -- cgit v1.2.1