Index: openacs-4/contrib/packages/bcms/tcl/bcms-item-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/bcms/tcl/bcms-item-procs-postgresql.xql,v
diff -u -r1.7 -r1.8
--- openacs-4/contrib/packages/bcms/tcl/bcms-item-procs-postgresql.xql	14 Oct 2003 14:58:31 -0000	1.7
+++ openacs-4/contrib/packages/bcms/tcl/bcms-item-procs-postgresql.xql	31 Oct 2003 09:01:42 -0000	1.8
@@ -6,22 +6,23 @@
         <fullquery name="bcms::item::create_item.create_item">
                 <querytext>
                         select content_item__new (
-                                :item_name,                             -- name
-                                integer :parent_id,     -- parent_id  for some reason PG gets confused on this param, explicit typecasting was needed
-                                null,                                   -- item_id
-                                null,                                   -- locale
-                                now(),                                  -- creation_date
-                                :creation_user_id,              -- creation_user
-                                :parent_id,                             -- context_id
-                                :creation_ip,                   -- creation_ip
-                                'content_revision',             -- item_subtype
-                                :content_type,              -- content_type
-                                null,                                   -- title
-                                null,                           -- description
-                                null,                                   -- mime_type
-                                null,                                   -- nls_language
-                                null,                                   -- data
-                                :storage_type                   -- storage_type
+                                :item_name,             -- name
+                                integer :parent_id,     -- parent_id  
+                                      -- for some reason PG gets confused on this param, explicit typecasting was needed
+                                :item_id,               -- item_id
+                                null,                   -- locale
+                                now(),                  -- creation_date
+                                :creation_user_id,      -- creation_user
+                                :parent_id,             -- context_id
+                                :creation_ip,           -- creation_ip
+                                'content_revision',     -- item_subtype
+                                :content_type,          -- content_type
+                                null,                   -- title
+                                null,                   -- description
+                                null,                   -- mime_type
+                                null,                   -- nls_language
+                                null,                   -- data
+                                :storage_type           -- storage_type
                         )
 
                 </querytext>
@@ -148,8 +149,8 @@
                             :item_id,           -- item_id
                             :related_object_id, -- related_object_id
                             :relation_type,     -- relation_tag
-                            null,               -- order_n
-                            'cr_item_rel'       -- relation_type
+                            :order_n,           -- order_n
+                            :relation_type      -- relation_type
             )
         </querytext>
     </fullquery>