cvs diff basSQL.bas (in directory F:\CVS\pgadmin\)
Index: basSQL.bas
===================================================================
RCS file: /usr/local/cvsroot/pgadmin/pgadmin/basSQL.bas,v
retrieving revision 1.2
diff -r1.2 basSQL.bas
56c56
< SQL_INS_PGADMIN_PARAM2 = "INSERT INTO pgadmin_param VALUES (2, 'N', 'Revision Tracking enabled?')"
---
> SQL_INS_PGADMIN_PARAM2 = "INSERT INTO pgadmin_param VALUES (2, 'iLoop', 'Revision Tracking enabled?')"
154a155,157
> ' 26/04/2001 Jean-Michel POURE
> ' When a function is deleted, triggers still exist with function = NULL value
> ' Therefore we must use a left join to retrieve the list of trigger values
160,161c163,165
<   "FROM pg_trigger t, pg_class c, pg_proc p " & _
<   "WHERE c.oid = t.tgrelid AND p.oid = tgfoid"
---
>   "FROM pg_trigger t " & _
>   "LEFT JOIN pg_class c ON c.oid = t.tgrelid " & _
>   "LEFT JOIN pg_proc  p ON p.oid = tgfoid "
625c629
<     If rsTables!table_name <> "pg_log" And rsTables!table_name <> "pg_variable" And rsTables!table_name <> "pg_xactlock" Then
---
>     If rsTables!Table_name <> "pg_log" And rsTables!Table_name <> "pg_variable" And rsTables!Table_name <> "pg_xactlock" Then
627,628c631,632
<       LogMsg "Executing: SELECT count(*) AS rows FROM " & QUOTE & rsTables!table_name & QUOTE
<       rsCount.Open "SELECT count(*) AS rows FROM " & QUOTE & rsTables!table_name & QUOTE, gConnection, adOpenForwardOnly
---
>       LogMsg "Executing: SELECT count(*) AS rows FROM " & QUOTE & rsTables!Table_name & QUOTE
>       rsCount.Open "SELECT count(*) AS rows FROM " & QUOTE & rsTables!Table_name & QUOTE, gConnection, adOpenForwardOnly