Index: openacs-4/packages/dotlrn-static/sql/postgresql/dotlrn-static-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn-static/sql/postgresql/dotlrn-static-create.sql,v
diff -u -r1.3 -r1.3.22.1
--- openacs-4/packages/dotlrn-static/sql/postgresql/dotlrn-static-create.sql	9 Aug 2002 18:39:30 -0000	1.3
+++ openacs-4/packages/dotlrn-static/sql/postgresql/dotlrn-static-create.sql	19 Aug 2014 07:33:37 -0000	1.3.22.1
@@ -23,141 +23,141 @@
 --
 -- PostGreSQL port samir@symphinity.com 11 July 2002
 --
-create function inline_0()
-returns integer as '
-begin
+CREATE OR REPLACE FUNCTION inline_0() RETURNS integer AS $$
+BEGIN
 	-- create the implementation
 	perform acs_sc_impl__new (
-		''dotlrn_applet'',
-		''dotlrn_static'',
-		''dotlrn_static''
+		'dotlrn_applet',
+		'dotlrn_static',
+		'dotlrn_static'
 	);
 
 	-- add all the hooks
 
 	-- GetPrettyName
 	perform acs_sc_impl_alias__new (
-	       ''dotlrn_applet'',
-	       ''dotlrn_static'',
-	       ''GetPrettyName'',
-	       ''dotlrn_static::get_pretty_name'',
-	       ''TCL''
+	       'dotlrn_applet',
+	       'dotlrn_static',
+	       'GetPrettyName',
+	       'dotlrn_static::get_pretty_name',
+	       'TCL'
 	);
 
 	-- AddApplet
 	perform acs_sc_impl_alias__new (
-	       ''dotlrn_applet'',
-	       ''dotlrn_static'',
-	       ''AddApplet'',
-	       ''dotlrn_static::add_applet'',
-	       ''TCL''
+	       'dotlrn_applet',
+	       'dotlrn_static',
+	       'AddApplet',
+	       'dotlrn_static::add_applet',
+	       'TCL'
 	);
 
 	-- RemoveApplet
 	perform acs_sc_impl_alias__new (
-	       ''dotlrn_applet'',
-	       ''dotlrn_static'',
-	       ''RemoveApplet'',
-	       ''dotlrn_static::remove_applet'',
-	       ''TCL''
+	       'dotlrn_applet',
+	       'dotlrn_static',
+	       'RemoveApplet',
+	       'dotlrn_static::remove_applet',
+	       'TCL'
 	);
 
 	-- AddAppletToCommunity
 	perform acs_sc_impl_alias__new (
-	       ''dotlrn_applet'',
-	       ''dotlrn_static'',
-	       ''AddAppletToCommunity'',
-	       ''dotlrn_static::add_applet_to_community'',
-	       ''TCL''
+	       'dotlrn_applet',
+	       'dotlrn_static',
+	       'AddAppletToCommunity',
+	       'dotlrn_static::add_applet_to_community',
+	       'TCL'
 	);
 
 	-- RemoveAppletFromCommunity
 	perform acs_sc_impl_alias__new (
-	       ''dotlrn_applet'',
-	       ''dotlrn_static'',
-	       ''RemoveAppletFromCommunity'',
-	       ''dotlrn_static::remove_applet_from_community'',
-	       ''TCL''
+	       'dotlrn_applet',
+	       'dotlrn_static',
+	       'RemoveAppletFromCommunity',
+	       'dotlrn_static::remove_applet_from_community',
+	       'TCL'
 	);
 
 	-- AddUser
 	perform acs_sc_impl_alias__new (
-	       ''dotlrn_applet'',
-	       ''dotlrn_static'',
-	       ''AddUser'',
-	       ''dotlrn_static::add_user'',
-	       ''TCL''
+	       'dotlrn_applet',
+	       'dotlrn_static',
+	       'AddUser',
+	       'dotlrn_static::add_user',
+	       'TCL'
 	);
 
 	-- RemoveUser
 	perform acs_sc_impl_alias__new (
-	       ''dotlrn_applet'',
-	       ''dotlrn_static'',
-	       ''RemoveUser'',
-	       ''dotlrn_static::remove_user'',
-	       ''TCL''
+	       'dotlrn_applet',
+	       'dotlrn_static',
+	       'RemoveUser',
+	       'dotlrn_static::remove_user',
+	       'TCL'
 	);
 
 	-- AddUserToCommunity
 	perform acs_sc_impl_alias__new (
-	       ''dotlrn_applet'',
-	       ''dotlrn_static'',
-	       ''AddUserToCommunity'',
-	       ''dotlrn_static::add_user_to_community'',
-	       ''TCL''
+	       'dotlrn_applet',
+	       'dotlrn_static',
+	       'AddUserToCommunity',
+	       'dotlrn_static::add_user_to_community',
+	       'TCL'
 	);
 
 	-- RemoveUserFromCommunity
 	perform acs_sc_impl_alias__new (
-	       ''dotlrn_applet'',
-	       ''dotlrn_static'',
-	       ''RemoveUserFromCommunity'',
-	       ''dotlrn_static::remove_user_from_community'',
-	       ''TCL''
+	       'dotlrn_applet',
+	       'dotlrn_static',
+	       'RemoveUserFromCommunity',
+	       'dotlrn_static::remove_user_from_community',
+	       'TCL'
 	);
 
     -- AddPortlet
 	perform acs_sc_impl_alias__new (
-        	''dotlrn_applet'',									-- impl_contract_name
-	        ''dotlrn_static'',									-- impl_name
- 	      	''AddPortlet'',										-- impl_operation_name
-  	      	''dotlrn_static::add_portlet'',						-- impl_alias
-   	     	''TCL''												-- impl_pl
+        	'dotlrn_applet',									-- impl_contract_name
+	        'dotlrn_static',									-- impl_name
+ 	      	'AddPortlet',										-- impl_operation_name
+  	      	'dotlrn_static::add_portlet',						-- impl_alias
+   	     	'TCL'												-- impl_pl
     	);
 	
     -- RemovePortlet
 	perform acs_sc_impl_alias__new (
-     	   	''dotlrn_applet'',
-      	  	''dotlrn_static'',
-       	 	''RemovePortlet'',
-        	''dotlrn_static::remove_portlet'',
-        	''TCL''
+     	   	'dotlrn_applet',
+      	  	'dotlrn_static',
+       	 	'RemovePortlet',
+        	'dotlrn_static::remove_portlet',
+        	'TCL'
     );
 
     -- Clone
     	perform acs_sc_impl_alias__new (
-        	''dotlrn_applet'',
-        	''dotlrn_static'',
-        	''Clone'',
-        	''dotlrn_static::clone'',
-        	''TCL''
+        	'dotlrn_applet',
+        	'dotlrn_static',
+        	'Clone',
+        	'dotlrn_static::clone',
+        	'TCL'
     	);
 
     perform acs_sc_impl_alias__new (
-        ''dotlrn_applet'',
-        ''dotlrn_static'',
-        ''ChangeEventHandler'',
-        ''dotlrn_static::change_event_handler'',
-        ''TCL''
+        'dotlrn_applet',
+        'dotlrn_static',
+        'ChangeEventHandler',
+        'dotlrn_static::change_event_handler',
+        'TCL'
     );
 
 	-- Add the binding
 	perform acs_sc_binding__new (
-	    	''dotlrn_applet'',
-	    	''dotlrn_static''
+	    	'dotlrn_applet',
+	    	'dotlrn_static'
 	);
 	return 0;
-end;' language 'plpgsql';
+END;
+$$ LANGUAGE plpgsql;
 
 select inline_0();
 
Index: openacs-4/packages/dotlrn-static/sql/postgresql/dotlrn-static-drop.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn-static/sql/postgresql/dotlrn-static-drop.sql,v
diff -u -r1.2 -r1.2.22.1
--- openacs-4/packages/dotlrn-static/sql/postgresql/dotlrn-static-drop.sql	9 Aug 2002 18:39:30 -0000	1.2
+++ openacs-4/packages/dotlrn-static/sql/postgresql/dotlrn-static-drop.sql	19 Aug 2014 07:33:37 -0000	1.2.22.1
@@ -23,117 +23,117 @@
 --
 -- PostGreSQL port samir@symphinity.com 11 July 2002
 --
-create function inline_0()
-returns integer as '
-begin
+CREATE OR REPLACE FUNCTION inline_0() RETURNS integer AS $$
+BEGIN
 
 	perform acs_sc_impl__delete(
-	   ''dotlrn_applet'',		-- impl_contract_name
-     ''dotlrn_static''		-- impl_name
+	   'dotlrn_applet',		-- impl_contract_name
+     'dotlrn_static'		-- impl_name
   );
 
 
 -- delete all the hooks
 
 -- GetPrettyName
 	perform  acs_sc_impl_alias__delete (
-	    ''dotlrn_applet'',
-	    ''dotlrn_static'',
-	    ''GetPrettyName''
+	    'dotlrn_applet',
+	    'dotlrn_static',
+	    'GetPrettyName'
  );
 
 
 	-- AddApplet
 	perform  acs_sc_impl_alias__delete (
-	       ''dotlrn_applet'',
-	       ''dotlrn_static'',
-	       ''AddApplet''
+	       'dotlrn_applet',
+	       'dotlrn_static',
+	       'AddApplet'
 	);
 
 
 
 	-- RemoveApplet
 	perform  acs_sc_impl_alias__delete (
-	       ''dotlrn_applet'',
-	       ''dotlrn_static'',
-	       ''RemoveApplet''
+	       'dotlrn_applet',
+	       'dotlrn_static',
+	       'RemoveApplet'
 	);
 
 	-- AddAppletToCommunity
 	perform  acs_sc_impl_alias__delete (
-	       ''dotlrn_applet'',
-	       ''dotlrn_static'',
-	       ''AddAppletToCommunity''
+	       'dotlrn_applet',
+	       'dotlrn_static',
+	       'AddAppletToCommunity'
 	);
 
 
 	-- RemoveAppletFromCommunity
 	perform  acs_sc_impl_alias__delete (
-	       ''dotlrn_applet'',
-	       ''dotlrn_static'',
-	       ''RemoveAppletFromCommunity''
+	       'dotlrn_applet',
+	       'dotlrn_static',
+	       'RemoveAppletFromCommunity'
 	);
 
 	-- AddUser
 	perform  acs_sc_impl_alias__delete (
-	       ''dotlrn_applet'',
-	       ''dotlrn_static'',
-	       ''AddUser''
+	       'dotlrn_applet',
+	       'dotlrn_static',
+	       'AddUser'
 	);
 
 	-- RemoveUser
 	perform  acs_sc_impl_alias__delete (
-	       ''dotlrn_applet'',
-	       ''dotlrn_static'',
-	       ''RemoveUser''
+	       'dotlrn_applet',
+	       'dotlrn_static',
+	       'RemoveUser'
 	);
 
 	-- AddUserToCommunity
 	perform  acs_sc_impl_alias__delete (
-	       ''dotlrn_applet'',
-	       ''dotlrn_static'',
-	       ''AddUserToCommunity''
+	       'dotlrn_applet',
+	       'dotlrn_static',
+	       'AddUserToCommunity'
 	);
 
 	-- RemoveUserFromCommunity
 	perform  acs_sc_impl_alias__delete (
-	       ''dotlrn_applet'',
-	       ''dotlrn_static'',
-	       ''RemoveUserFromCommunity''
+	       'dotlrn_applet',
+	       'dotlrn_static',
+	       'RemoveUserFromCommunity'
 	);
 
     -- AddPortlet
 	perform  acs_sc_impl_alias__delete (
-        	''dotlrn_applet'',									-- impl_contract_name
-	        ''dotlrn_static'',									-- impl_name
- 	      	''AddPortlet''  										-- impl_operation_name
+        	'dotlrn_applet',									-- impl_contract_name
+	        'dotlrn_static',									-- impl_name
+ 	      	'AddPortlet'  										-- impl_operation_name
     	);
 	
     -- RemovePortlet
 	perform  acs_sc_impl_alias__delete (
-     	   	''dotlrn_applet'',
-     	  	''dotlrn_static'',
-       	 	''RemovePortlet''
+     	   	'dotlrn_applet',
+     	  	'dotlrn_static',
+       	 	'RemovePortlet'
     );
 
     -- Clone
 	perform  acs_sc_impl_alias__delete (
-        	''dotlrn_applet'',
-        	''dotlrn_static'',
-        	''Clone''
+        	'dotlrn_applet',
+        	'dotlrn_static',
+        	'Clone'
     	);
 
 
 	-- Remove the binding
 	perform acs_sc_binding__delete (
-	    ''dotlrn_applet'',
-	    ''dotlrn_static''
+	    'dotlrn_applet',
+	    'dotlrn_static'
 		);
 
-	RAISE NOTICE '' Finished deleting dotlrn-static sc....'';
+	RAISE NOTICE ' Finished deleting dotlrn-static sc....';
 	
 return 0;
-end;' language 'plpgsql';
+END;
+$$ LANGUAGE plpgsql;
 
 select inline_0();