Index: openacs-4/packages/bm-portlet/bm-portlet.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/bm-portlet/bm-portlet.info,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/bm-portlet/bm-portlet.info	15 May 2002 22:11:37 -0000	1.1
+++ openacs-4/packages/bm-portlet/bm-portlet.info	21 Jul 2002 21:25:16 -0000	1.2
@@ -23,12 +23,14 @@
             <file type="package_spec" path="bm-portlet.info"/>
             <file type="data_model_create" db_type="oracle" path="sql/oracle/bm-portlet-create.sql"/>
             <file type="data_model_drop" db_type="oracle" path="sql/oracle/bm-portlet-drop.sql"/>
+            <file type="data_model_create" db_type="postgresql" path="sql/postgresql/bm-portlet-create.sql"/>
+            <file type="data_model_drop" db_type="postgresql" path="sql/postgresql/bm-portlet-drop.sql"/>
             <file type="tcl_procs" path="tcl/bm-portlet-procs.tcl"/>
             <file type="content_page" path="www/bm-portlet.adp"/>
             <file type="content_page" path="www/bm-portlet.tcl"/>
         </files>
         <parameters>
-            <parameter datatype="string"  min_n_values="1"  max_n_values="1" name="PrettyName"  default="Bulk Mail" description="Name of the bulk mail portlet to display everywhere"/>
+            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="PrettyName"  default="Bulk Mail" description="Name of the bulk mail portlet to display everywhere"/>
         </parameters>
 
     </version>
Index: openacs-4/packages/dotlrn-forums/dotlrn-forums.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn-forums/dotlrn-forums.info,v
diff -u -r1.5 -r1.6
--- openacs-4/packages/dotlrn-forums/dotlrn-forums.info	9 Jul 2002 19:48:46 -0000	1.5
+++ openacs-4/packages/dotlrn-forums/dotlrn-forums.info	21 Jul 2002 21:26:28 -0000	1.6
@@ -21,8 +21,10 @@
         <files>
             <file type="package_spec" path="dotlrn-forums.info"/>
             <file type="data_model_create" db_type="oracle" path="sql/oracle/dotlrn-forums-create.sql"/>
+            <file type="data_model_create" db_type="postgresql" path="sql/postgresql/dotlrn-forums-create.sql"/>
             <file type="tcl_procs" path="tcl/dotlrn-forums-procs.tcl"/>
             <file type="query_file" db_type="oracle" path="www/user-oracle.xql"/>
+            <file type="query_file" db_type="postgresql" path="www/user-postgresql.xql"/>
             <file type="content_page" path="www/user.adp"/>
             <file type="content_page" path="www/user.tcl"/>
         </files>
Index: openacs-4/packages/dotlrn-static/dotlrn-static.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn-static/dotlrn-static.info,v
diff -u -r1.5 -r1.6
--- openacs-4/packages/dotlrn-static/dotlrn-static.info	31 May 2002 13:04:23 -0000	1.5
+++ openacs-4/packages/dotlrn-static/dotlrn-static.info	21 Jul 2002 21:26:05 -0000	1.6
@@ -21,6 +21,8 @@
         <files>
             <file type="package_spec" path="dotlrn-static.info"/>
             <file type="data_model_create" db_type="oracle" path="sql/oracle/dotlrn-static-create.sql"/>
+            <file type="data_model_create" db_type="postgresql" path="sql/postgresql/dotlrn-static-create.sql"/>
+            <file type="data_model_drop" db_type="postgresql" path="sql/postgresql/dotlrn-static-drop.sql"/>
             <file type="tcl_procs" path="tcl/dotlrn-static-procs.tcl"/>
         </files>
         <parameters>
Index: openacs-4/packages/forums-portlet/forums-portlet.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/forums-portlet/forums-portlet.info,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/forums-portlet/forums-portlet.info	31 May 2002 13:03:32 -0000	1.2
+++ openacs-4/packages/forums-portlet/forums-portlet.info	21 Jul 2002 21:26:35 -0000	1.3
@@ -24,10 +24,17 @@
             <file type="data_model" db_type="oracle" path="sql/oracle/forums-admin-portlet-create.sql"/>
             <file type="data_model_create" db_type="oracle" path="sql/oracle/forums-portlet-create.sql"/>
             <file type="data_model_drop" db_type="oracle" path="sql/oracle/forums-portlet-drop.sql"/>
+            <file type="data_model" db_type="postgresql" path="sql/postgresql/forums-admin-portlet-create.sql"/>
+            <file type="data_model_create" db_type="postgresql" path="sql/postgresql/forums-portlet-create.sql"/>
+            <file type="data_model_drop" db_type="postgresql" path="sql/postgresql/forums-portlet-drop.sql"/>
             <file type="tcl_procs" path="tcl/forums-admin-portlet-procs.tcl"/>
             <file type="tcl_procs" path="tcl/forums-portlet-procs.tcl"/>
             <file type="content_page" path="www/forums-admin-portlet.adp"/>
             <file type="content_page" path="www/forums-admin-portlet.tcl"/>
+            <file type="query_file" db_type="oracle" path="www/forums-portlet-oracle.xql"/>
+            <file type="query_file" db_type="postgresql" path="www/forums-portlet-postgresql.xql"/>
+            <file type="content_page" path="www/forums-portlet.adp"/>
+            <file type="content_page" path="www/forums-portlet.tcl"/>
         </files>
         <parameters>
             <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="forums_portlet_region"  default="1" description="the defailt region for this portlet"/>
Index: openacs-4/packages/forums-portlet/www/forums-portlet-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/forums-portlet/www/Attic/forums-portlet-postgresql.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/forums-portlet/www/forums-portlet-postgresql.xql	21 Jul 2002 20:13:29 -0000	1.1
+++ openacs-4/packages/forums-portlet/www/forums-portlet-postgresql.xql	21 Jul 2002 21:26:35 -0000	1.2
@@ -1,12 +1,12 @@
 <?xml version="1.0"?>
 
 <queryset>
-    <rdbms><type>postgresql</type><version>7.2.1</version></rdbms>
+    <rdbms><type>postgresql</type><version>7.1</version></rdbms>
 
     <fullquery name="select_forums">
         <querytext>
 	    select forums_forums.package_id,
-            acs_object__name(apm_package.parent_id(forums_forums.package_id)) as parent_name,
+            acs_object__name(apm_package__parent_id(forums_forums.package_id)) as parent_name,
             (select site_node__url(site_nodes.node_id)
             from site_nodes
             where site_nodes.object_id = forums_forums.package_id) as url,
@@ -22,4 +22,4 @@
         </querytext>
     </fullquery>
 
-</queryset>
\ No newline at end of file
+</queryset>
Index: openacs-4/packages/notifications/sql/postgresql/notifications-package-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/notifications/sql/postgresql/notifications-package-create.sql,v
diff -u -r1.4 -r1.5
--- openacs-4/packages/notifications/sql/postgresql/notifications-package-create.sql	1 Jul 2002 04:07:44 -0000	1.4
+++ openacs-4/packages/notifications/sql/postgresql/notifications-package-create.sql	21 Jul 2002 21:25:02 -0000	1.5
@@ -58,7 +58,7 @@
 returns integer as '
 declare
     p_delivery_method_id            alias for $1;
-    p_sc_impl_id		    alias for $2;
+    p_sc_impl_id                    alias for $2;
     p_short_name                    alias for $3;
     p_pretty_name                   alias for $4;
     p_creation_date                 alias for $5;
@@ -90,10 +90,10 @@
 create function notification_delivery_method__delete(integer)
 returns integer as '
 DECLARE
-	p_delivery_method_id		alias for $1;
+        p_delivery_method_id            alias for $1;
 BEGIN
-	perform acs_object__delete(p_delivery_method_id);
-	return 0;
+        perform acs_object__delete(p_delivery_method_id);
+        return 0;
 END;
 ' language 'plpgsql';
 
@@ -109,24 +109,24 @@
 create function notification_type__new (integer,integer,varchar,varchar,varchar,timestamp,integer,varchar,integer)
 returns integer as '
 DECLARE
-	p_type_id			alias for $1;
+        p_type_id                       alias for $1;
         p_sc_impl_id                    alias for $2;
-	p_short_name			alias for $3;
-	p_pretty_name			alias for $4;
-	p_description			alias for $5;
-	p_creation_date			alias for $6;
-	p_creation_user			alias for $7;
-	p_creation_ip			alias for $8;
-	p_context_id			alias for $9;
-	v_type_id			integer;
+        p_short_name                    alias for $3;
+        p_pretty_name                   alias for $4;
+        p_description                   alias for $5;
+        p_creation_date                 alias for $6;
+        p_creation_user                 alias for $7;
+        p_creation_ip                   alias for $8;
+        p_context_id                    alias for $9;
+        v_type_id                       integer;
 BEGIN
-	v_type_id:= acs_object__new (
-				    p_type_id,
-				    ''notification_type'',
-				    p_creation_date,
-				    p_creation_user,
-				    p_creation_ip,
-				    p_context_id);
+        v_type_id:= acs_object__new (
+                                    p_type_id,
+                                    ''notification_type'',
+                                    p_creation_date,
+                                    p_creation_user,
+                                    p_creation_ip,
+                                    p_context_id);
 
       insert into notification_types
       (type_id, sc_impl_id, short_name, pretty_name, description) values
@@ -150,30 +150,30 @@
 
 select define_function_args ('notification_request__new','request_id,object_type;notification_request,type_id,user_id,object_id,interval_id,delivery_method_id,format,creation_date,creation_user,creation_ip,context_id');
 
-create function notification_request__new (integer,varchar,integer,integer,integer,integer,varchar,timestamp,integer,varchar,integer)
+create function notification_request__new (integer,varchar,integer,integer,integer,integer,integer,varchar,timestamp,integer,varchar,integer)
 returns integer as '
 DECLARE
-	p_request_id				alias for $1;
-	p_object_type				alias for $2;
-	p_type_id				alias for $3;
-	p_user_id				alias for $4;
-	p_object_id				alias for $5;
-	p_interval_id				alias for $6;
-	p_delivery_method_id			alias for $7;
-	p_format				alias for $8;
-	p_creation_date				alias for $9;
-	p_creation_user				alias for $10;
-	p_creation_ip				alias for $11;
-	p_context_id				alias for $12;
-	v_request_id				integer;
+        p_request_id                            alias for $1;
+        p_object_type                           alias for $2;
+        p_type_id                               alias for $3;
+        p_user_id                               alias for $4;
+        p_object_id                             alias for $5;
+        p_interval_id                           alias for $6;
+        p_delivery_method_id                    alias for $7;
+        p_format                                alias for $8;
+        p_creation_date                         alias for $9;
+        p_creation_user                         alias for $10;
+        p_creation_ip                           alias for $11;
+        p_context_id                            alias for $12;
+        v_request_id                            integer;
 BEGIN
-	v_request_id:= acs_object__new (
-				       p_request_id,
-				       p_object_type,
-				       p_creation_date,
-				       p_creation_user,
-				       p_creation_ip,
-				       p_context_id);
+        v_request_id:= acs_object__new (
+                                       p_request_id,
+                                       p_object_type,
+                                       p_creation_date,
+                                       p_creation_user,
+                                       p_creation_ip,
+                                       p_context_id);
 
       insert into notification_requests
       (request_id, type_id, user_id, object_id, interval_id, delivery_method_id, format) values
Index: openacs-4/packages/notifications/tcl/notification-request-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/notifications/tcl/notification-request-procs-postgresql.xql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/notifications/tcl/notification-request-procs-postgresql.xql	3 Jun 2002 22:27:00 -0000	1.2
+++ openacs-4/packages/notifications/tcl/notification-request-procs-postgresql.xql	21 Jul 2002 21:25:02 -0000	1.3
@@ -9,4 +9,10 @@
         </querytext>
     </fullquery>
 
+    <fullquery name="notification::request::delete_all.delete_all_requests">
+        <querytext>
+            select notification_request__delete_all(:object_id);
+        </querytext>
+    </fullquery>
+
 </queryset>
Index: openacs-4/packages/static-portlet/static-portlet.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/static-portlet/static-portlet.info,v
diff -u -r1.7 -r1.8
--- openacs-4/packages/static-portlet/static-portlet.info	31 May 2002 13:03:06 -0000	1.7
+++ openacs-4/packages/static-portlet/static-portlet.info	21 Jul 2002 21:25:57 -0000	1.8
@@ -24,9 +24,20 @@
             <file type="data_model" db_type="oracle" path="sql/oracle/static-core.sql"/>
             <file type="data_model_create" db_type="oracle" path="sql/oracle/static-portlet-create.sql"/>
             <file type="data_model" db_type="oracle" path="sql/oracle/static-portlet.sql"/>
+            <file type="data_model" db_type="postgresql" path="sql/postgresql/static-admin-portlet-drop.sql"/>
+            <file type="data_model" db_type="postgresql" path="sql/postgresql/static-admin-portlet.sql"/>
+            <file type="data_model" db_type="postgresql" path="sql/postgresql/static-core-drop.sql"/>
+            <file type="data_model" db_type="postgresql" path="sql/postgresql/static-core.sql"/>
+            <file type="data_model_create" db_type="postgresql" path="sql/postgresql/static-portlet-create.sql"/>
+            <file type="data_model_drop" db_type="postgresql" path="sql/postgresql/static-portlet-drop.sql"/>
+            <file type="data_model" db_type="postgresql" path="sql/postgresql/static-portlet-portlet-drop.sql"/>
+            <file type="data_model" db_type="postgresql" path="sql/postgresql/static-portlet.sql"/>
             <file type="package_spec" path="static-portlet.info"/>
             <file type="tcl_procs" path="tcl/static-admin-portlet-procs.tcl"/>
+            <file type="query_file" db_type="oracle" path="tcl/static-portal-content-procs-oracle.xql"/>
+            <file type="query_file" db_type="postgresql" path="tcl/static-portal-content-procs-postgresql.xql"/>
             <file type="tcl_procs" path="tcl/static-portal-content-procs.tcl"/>
+            <file type="query_file" path="tcl/static-portal-content-procs.xql"/>
             <file type="tcl_procs" path="tcl/static-portlet-procs.tcl"/>
             <file type="content_page" path="www/element-delete.tcl"/>
             <file type="content_page" path="www/element-new.adp"/>