Index: openacs-4/packages/acs-content-repository/tcl/item-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/tcl/Attic/item-procs-postgresql.xql,v
diff -u -N -r1.5 -r1.6
--- openacs-4/packages/acs-content-repository/tcl/item-procs-postgresql.xql	16 Jan 2004 04:38:39 -0000	1.5
+++ openacs-4/packages/acs-content-repository/tcl/item-procs-postgresql.xql	16 Jan 2004 18:29:32 -0000	1.6
@@ -93,5 +93,27 @@
       )
     </querytext>
 </fullquery>
+
+
+<fullquery name="item::publish.set_live">
+    <querytext>
+        begin
+            content_item.set_live_revision(
+                revision_id => :revision_id,
+                publish_status => 'live'
+            );
+        end;
+    </querytext>
+</fullquery>
+
+<fullquery name="item::unpublish.unset_live">
+    <querytext>
+        begin
+            content_item__unset_live_revision(
+                 :item_id
+            );
+        end;
+    </querytext>
+</fullquery>
       
 </queryset>