Index: openacs-4/packages/acs-lang/tcl/lang-message-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-lang/tcl/lang-message-procs-postgresql.xql,v
diff -u -r1.8 -r1.8.2.1
--- openacs-4/packages/acs-lang/tcl/lang-message-procs-postgresql.xql	22 Sep 2003 11:49:01 -0000	1.8
+++ openacs-4/packages/acs-lang/tcl/lang-message-procs-postgresql.xql	9 Dec 2003 13:41:52 -0000	1.8.2.1
@@ -1,26 +1,36 @@
-
 <?xml version="1.0"?>
 <queryset>
   <rdbms><type>postgresql</type><version>7.2</version></rdbms>
 
+  <fullquery name="lang::message::register.lang_message_update">
+      <querytext>
+        update lang_messages
+        set    [join $set_clauses ", "]
+        where  locale = :locale
+        and    message_key = :message_key
+        and    package_key = :package_key
+      </querytext>
+  </fullquery>
+
   <fullquery name="lang::message::register.lang_message_insert">      
     <querytext>
-      insert into lang_messages (package_key, message_key, locale, message, upgrade_status, creation_user) 
-      values (:package_key, :message_key, :locale, :message, :message_upgrade_status, :creation_user) 
+      insert into lang_messages ([join $col_clauses ", "]) 
+      values ([join $val_clauses ", "])
     </querytext>
   </fullquery>
 
- <fullquery name="lang::message::register.lang_message_update">
-     <querytext>
-       update lang_messages
-       set    message = :message,
-              upgrade_status = :message_upgrade_status
-       where  locale = :locale
-       and    message_key = :message_key
-       and    package_key = :package_key
-     </querytext>
- </fullquery>
+  <partialquery name="lang::message::register.sync_time">
+    <querytext>
+        current_timestamp
+    </querytext>
+  </partialquery>
 
+  <partialquery name="lang::message::register.message">
+    <querytext>
+        :message
+    </querytext>
+  </partialquery>
+
   <fullquery name="lang::message::update_description.update_description">
     <querytext>
       update lang_message_keys
@@ -30,4 +40,10 @@
     </querytext>
   </fullquery>
 
+  <partialquery name="lang::message::edit.set_sync_time_now">
+      <querytext>
+        sync_time = current_timestamp
+      </querytext>
+  </partialquery>
+
 </queryset>