|
15 | 15 | /** |
16 | 16 | * This class provides information about the database as a whole. |
17 | 17 | * |
18 | | - * $Id: DatabaseMetaData.java,v 1.42 2001/10/31 20:27:37 davec Exp $ |
| 18 | + * $Id: DatabaseMetaData.java,v 1.43 2001/11/02 23:51:18 davec Exp $ |
19 | 19 | * |
20 | 20 | * <p>Many of the methods here return lists of information in ResultSets. You |
21 | 21 | * can use the normal ResultSet methods such as getString and getInt to |
@@ -2643,19 +2643,17 @@ public java.sql.ResultSet getExportedKeys(String catalog, String schema, String |
2643 | 2643 | +"a.tgdeferrable," |
2644 | 2644 | +"a.tginitdeferred " |
2645 | 2645 | +"FROM " |
2646 | | - +"(SELECT t.tgargs, t.tgconstrname, p.proname, t.tgdeferrable," |
2647 | | - +"t.tginitdeferred " |
| 2646 | + +"(SELECT t.tgargs, t.tgconstrname, p.proname," |
| 2647 | + +"t.tgdeferrable, t.tginitdeferred " |
2648 | 2648 | +"FROM pg_class as c, pg_proc as p, pg_trigger as t " |
2649 | | - +"WHERE c.relfilenode=t.tgrelidANDt.tgfoid = p.oid " |
2650 | | - +"ANDp.proname LIKE 'RI_FKey_%_upd') as a," |
| 2649 | + +"WHERE c.relname like '"+table+"'ANDc.relfilenode=t.tgrelid " |
| 2650 | + +"ANDt.tgfoid = p.oid AND p.proname LIKE 'RI_FKey_%_upd') as a," |
2651 | 2651 | +"(SELECT t.tgconstrname, p.proname " |
2652 | 2652 | +"FROM pg_class as c, pg_proc as p, pg_trigger as t " |
2653 | | - +"WHERE c.relfilenode=t.tgrelid AND t.tgfoid = p.oid " |
2654 | | - +"AND p.proname LIKE 'RI_FKey_%_del') as b," |
2655 | | - +"(SELECT t.tgconstrname FROM pg_class as c, pg_trigger as t " |
2656 | | - +"WHERE c.relname like '"+table+"' AND c.relfilenode=t.tgrelid) as c " |
2657 | | - +"WHERE a.tgconstrname=b.tgconstrname AND a.tgconstrname=c.tgconstrname" |
2658 | | - ); |
| 2653 | + +"WHERE c.relname like '"+table+"' AND c.relfilenode=t.tgrelid " |
| 2654 | + +"AND t.tgfoid = p.oid AND p.proname LIKE 'RI_FKey_%_del') as b " |
| 2655 | + +"WHERE a.tgconstrname=b.tgconstrname" |
| 2656 | + ); |
2659 | 2657 | Vectortuples =newVector(); |
2660 | 2658 |
|
2661 | 2659 | while (rs.next()) |
|
