Index: openacs-4/packages/logger/tcl/variable-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/logger/tcl/variable-procs-postgresql.xql,v
diff -u -r1.3 -r1.4
--- openacs-4/packages/logger/tcl/variable-procs-postgresql.xql	29 Sep 2003 10:21:52 -0000	1.3
+++ openacs-4/packages/logger/tcl/variable-procs-postgresql.xql	3 Jun 2004 21:08:24 -0000	1.4
@@ -23,6 +23,22 @@
     </querytext>
   </fullquery>
  
+  <fullquery name="logger::variable::get_default_variable_id.select_first_project_primary_variable">
+    <querytext>
+            select vm.variable_id
+            from   logger_project_var_map vm,
+                   logger_project_pkg_map pm,
+                   logger_projects p
+            where  vm.primary_p = 't'
+            and    vm.project_id = pm.project_id
+            and    pm.package_id = :package_id
+            and    p.project_id = pm.project_id
+            and    p.active_p = 't'
+            order  by lower(p.name)
+      limit 1
+    </querytext>
+  </fullquery>
+
   <fullquery name="logger::variable::get_default_variable_id.select_first_variable_id">
     <querytext>
         select variable_id