Index: openacs-4/packages/news/sql/postgresql/news-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/news/sql/postgresql/news-create.sql,v
diff -u -r1.15 -r1.16
--- openacs-4/packages/news/sql/postgresql/news-create.sql	6 Oct 2003 12:11:23 -0000	1.15
+++ openacs-4/packages/news/sql/postgresql/news-create.sql	12 Mar 2004 19:19:48 -0000	1.16
@@ -887,7 +887,7 @@
     ci.item_id as item_id,
     cn.package_id as package_id,
     revision_id,        
-    title as publish_title,
+    cr.title as publish_title,
     cr.content as publish_body,
     (case when cr.mime_type = 'text/html' then 't' else 'f' end) as html_p,
     cr.publish_date,
