Index: openacs-4/packages/cms/www/modules/types/register-templates-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/cms/www/modules/types/register-templates-postgresql.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/cms/www/modules/types/register-templates-postgresql.xql	25 May 2001 23:49:05 -0000	1.1
+++ openacs-4/packages/cms/www/modules/types/register-templates-postgresql.xql	8 Jun 2001 01:44:53 -0000	1.2
@@ -15,5 +15,30 @@
       </querytext>
 </fullquery>
 
+
+<fullquery name="get_content_templates">      
+      <querytext>
+
+  select 
+    template_id, 
+    content_item__get_path( template_id, content_template__get_root_folder() ) 
+      as name
+  from 
+    cr_templates t, cr_items i
+  where 
+    t.template_id = i.item_id
+  and not exists (
+    select 1 
+    from 
+      cr_type_template_map
+    where 
+      template_id = t.template_id
+    and 
+      content_type = :content_type )
+  and 
+    $marked_templates_sql
+
+      </querytext>
+</fullquery>
  
 </queryset>