[Squirrel-sql-commits] sql12/plugins/postgres/src/net/sourceforge/squirrel_sql/plugins/postgres/exp TriggerParentExpander.java, 1.1, 1.2

[Rob M. <man...@us...>]

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 ----