Index: openacs-4/packages/acs-tcl/tcl/apm-file-procs.postgresql.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-tcl/tcl/Attic/apm-file-procs.postgresql.sql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/acs-tcl/tcl/apm-file-procs.postgresql.sql	3 Apr 2001 02:41:34 -0000	1.1
@@ -0,0 +1,26 @@
+<?xml version="1.0"?>
+<queryset>
+
+<fullquery name="acs.acs-tcl.tcl.apm-file-procs.apm_file_add.apm_file_add">
+<querytext>
+select apm_package_version__add_file(
+	NULL,
+	:version_id,
+	:path,
+	:file_type
+)
+</querytext>
+<rdbms><type>postgresql</type><version>7.1</version></rdbms>
+</fullquery>
+
+<fullquery name="acs.acs-tcl.tcl.apm-file-procs.apm_file_remove.apm_file_remove">
+<querytext>
+selec apm_package_version__remove_file (
+      :path,
+      :version_id
+)
+</querytext>
+<rdbms><type>postgresql</type><version>7.1</version></rdbms>
+</fullquery>
+
+</queryset>
Index: openacs-4/packages/acs-tcl/tcl/apm-procs.postgresql.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-tcl/tcl/Attic/apm-procs.postgresql.sql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/acs-tcl/tcl/apm-procs.postgresql.sql	30 Mar 2001 05:45:22 -0000	1.1
+++ openacs-4/packages/acs-tcl/tcl/apm-procs.postgresql.sql	3 Apr 2001 02:41:34 -0000	1.2
@@ -19,12 +19,32 @@
 
 <fullquery name="acs.acs-tcl.tcl.apm-procs.apm_parameter_register.apm_parameter_cache_update">
 <querytext>
-select v.package_id, p.parameter_name, coalesce(p.default_value, v.attr_value) attr_value
-from apm_parameters p, apm_parameter_values v
+select v.package_id, p.parameter_name, coalesce(p.default_value, v.attr_value) as attr_value
+from apm_parameters p LEFT JOIN apm_parameter_values v using (parameter_id)
 where p.package_key = :package_key
-and p.parameter_id = v.parameter_id (+)
 </querytext>
 <rdbms><type>postgresql</type><version>7.1</version></rdbms>
 </fullquery>
 
+<fullquery name="acs.acs-tcl.tcl.apm-procs.apm_interface_add.interface_add">
+<querytext>
+select apm_package_version__add_interface(
+    :interface_id,
+    :version_id,
+    :interface_uri,
+    :interface_version
+)					 
+</querytext>
+<rdbms><type>postgresql</type><version>7.1</version></rdbms>
+</fullquery>
+
+<fullquery name="acs.acs-tcl.tcl.apm-procs.apm_interface_remove.interface_remove">
+<querytext>
+select apm_package_version__remove_interface(
+             :interface_id
+);
+</querytext>
+<rdbms><type>postgresql</type><version>7.1</version></rdbms>
+</fullquery>
+
 </queryset>