Index: openacs-4/packages/press/sql/postgresql/press-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/press/sql/postgresql/press-create.sql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/press/sql/postgresql/press-create.sql	4 Nov 2003 20:02:27 -0000	1.2
+++ openacs-4/packages/press/sql/postgresql/press-create.sql	12 Mar 2004 19:19:48 -0000	1.3
@@ -374,7 +374,7 @@
 as 
 select ci.item_id as item_id,
        press_id,
-       package_id,
+       cp.package_id,
        publication_name,
        publication_link,
        publication_date,
@@ -403,7 +403,7 @@
 create or replace view press_items_approved
 as
 select ci.item_id as item_id,
-       package_id,
+       cp.package_id,
        publication_name,
        publication_link,
        publication_date,
@@ -431,15 +431,15 @@
 as 
 select revision_id,
        cr.item_id as item_id,
-       package_id,
-       publication_name,
-       publication_link,
-       publication_date,
-       publication_date_desc,
+       cp.package_id,
+       cp.publication_name,
+       cp.publication_link,
+       cp.publication_date,
+       cp.publication_date_desc,
        cr.title as article_title,
        cr.content as article_abstract,
        cr.description as revision_note,
-       article_link,
+       cp.article_link,
        article_pages,
        article_abstract_html_p as html_p,
        release_date,