Update of /cvsroot/squirrel-sql/sql12/plugins/postgres/src/net/sourceforge/squirrel_sql/plugins/postgres/exp
In directory sc8-pr-cvs8.sourceforge.net:/tmp/cvs-serv30691/plugins/postgres/src/net/sourceforge/squirrel_sql/plugins/postgres/exp
Modified Files:
TriggerParentExpander.java
Log Message:
Alternate system catalog query for triggers. Not sure which one is better - information_schema query is certainly more readable, but not sure how portable (across pg versions) it is.
Index: TriggerParentExpander.java
===================================================================
RCS file: /cvsroot/squirrel-sql/sql12/plugins/postgres/src/net/sourceforge/squirrel_sql/plugins/postgres/exp/TriggerParentExpander.java,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -d -r1.1 -r1.2
*** TriggerParentExpander.java 18 Jan 2007 03:36:48 -0000 1.1
--- TriggerParentExpander.java 19 Jan 2007 15:00:13 -0000 1.2
***************
*** 47,55 ****
private static String SQL =
! "select trigger_name " +
! "from information_schema.triggers " +
! //"where trigger_catalog = ? " +
! "where trigger_schema = ? " +
! "and event_object_table = ? ";
/**
--- 47,57 ----
private static String SQL =
! "select tr.tgname " +
! "from pg_catalog.pg_trigger tr, pg_catalog.pg_proc p, pg_class c, pg_namespace n " +
! "where tr.tgfoid = p.oid " +
! "and tr.tgrelid = c.oid " +
! "and c.relnamespace = n.oid " +
! "and n.nspname = ? " +
! "and c.relname = ? ";
/**
***************
*** 93,97 ****
}
pstmt = conn.prepareStatement(SQL);
- //pstmt.setString(1, tableInfo.getCatalogName());
pstmt.setString(1, tableInfo.getSchemaName());
pstmt.setString(2, tableInfo.getSimpleName());
--- 95,98 ----
|