Index: openacs-4/packages/acs-admin/acs-admin.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-admin/acs-admin.info,v
diff -u -r1.12 -r1.13
--- openacs-4/packages/acs-admin/acs-admin.info	3 Oct 2001 23:35:49 -0000	1.12
+++ openacs-4/packages/acs-admin/acs-admin.info	3 Jul 2002 10:06:16 -0000	1.13
@@ -90,6 +90,7 @@
             <file type="query_file" path="www/apm/version-edit.xql"/>
             <file type="content_page" path="www/apm/version-enable.tcl"/>
             <file type="query_file" db_type="oracle" path="www/apm/version-files-oracle.xql"/>
+            <file type="query_file" db_type="postgresql" path="www/apm/version-files-postgresql.xql"/>
             <file type="content_page" path="www/apm/version-files.tcl"/>
             <file type="query_file" path="www/apm/version-files.xql"/>
             <file type="content_page" path="www/apm/version-fs-scan.tcl"/>
Index: openacs-4/packages/acs-admin/www/apm/version-files-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-admin/www/apm/Attic/version-files-postgresql.xql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/acs-admin/www/apm/version-files-postgresql.xql	3 Jul 2002 10:06:16 -0000	1.1
@@ -0,0 +1,17 @@
+<?xml version="1.0"?>
+<queryset>
+    <rdbms><type>postgresql</type><version>7.1</version></rdbms>
+ 
+<fullquery name="apm_all_files">      
+      <querytext>
+    select ftd.file_id, ftd.path, ftd.file_type, coalesce(ftd.pretty_name, 'Unknown type') as file_pretty_name,
+           ftd.db_type, coalesce(ftd.pretty_db_name, 'All') as db_pretty_name
+    from   ((apm_package_files f left join apm_package_file_types t on (f.file_type = t.file_type_key))
+            left join apm_package_db_types d on (f.db_type = d.db_type_key)) ftd
+    where  ftd.version_id = :version_id
+    order by ftd.path
+
+      </querytext>
+</fullquery>
+
+</queryset>
Index: openacs-4/packages/acs-admin/www/apm/version-files.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-admin/www/apm/Attic/version-files.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/acs-admin/www/apm/version-files.xql	27 Apr 2001 01:41:12 -0000	1.1
+++ openacs-4/packages/acs-admin/www/apm/version-files.xql	3 Jul 2002 10:06:16 -0000	1.2
@@ -11,25 +11,4 @@
       </querytext>
 </fullquery>
 
- 
-<fullquery name="apm_all_files">      
-      <querytext>
-    select ftd.file_id, ftd.path, ftd.file_type, coalesce(ftd.pretty_name, 'Unknown type') as file_pretty_name,
-           ftd.db_type, coalesce(ftd.pretty_db_name, 'All') as db_pretty_name
-    from   ((apm_package_files f left join apm_package_file_types t on (f.file_type = t.file_type_key))
-            left join apm_package_db_types d on (f.db_type = d.db_type_key)) ftd
-    where  ftd.version_id = :version_id
-    order by ftd.path
-
-      </querytext>
-</fullquery>
-
- 
-<fullquery name="">      
-      <querytext>
-       
-      </querytext>
-</fullquery>
-
- 
 </queryset>