Forum OpenACS Development: Response to Would a list of pg7.2 issues be useful?

Ok, that's one screen before the schreenshot I've posted. We can diff the plsql-subprograms-all*.{adp,tcl,xql} files and see what's different between yours and mine. For starter (that's from WNT machine), some stats:

[ ~/projects/oaks/packages/acs-api-browser/www ]
$ ls -l plsql-sub*-all*
-rw-r--r--    1 a-popov  None          431 Feb 17 23:10 plsql-subprograms-all-oracle.xql
-rw-r--r--    1 a-popov  None          386 Feb 17 23:10 plsql-subprograms-all-postgresql.xql
-rw-r--r--    1 a-popov  None          494 Mar 13  2001 plsql-subprograms-all.adp
-rw-r--r--    1 a-popov  None          772 Feb 17 23:10 plsql-subprograms-all.tcl

and -postgresql.xql file is:

<?xml version="1.0"?>

<queryset>
   <rdbms><type>postgresql</type><version>7.1</version></rdbms>

<fullquery name="all_subprograms">
      <querytext>

        select proname as name, 'FUNCTION' as type
        from pg_proc
        where proowner=(select usesysid from pg_shadow
                        where usename = current_user)
        order by proname

      </querytext>
</fullquery>


</queryset>