Index: openacs-4/packages/acs-kernel/sql/postgresql/journal-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/journal-create.sql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/acs-kernel/sql/postgresql/journal-create.sql	17 Apr 2001 23:41:36 -0000	1.2
+++ openacs-4/packages/acs-kernel/sql/postgresql/journal-create.sql	28 Apr 2001 17:35:30 -0000	1.3
@@ -47,9 +47,9 @@
   object_id 		integer
 			constraint journal_entries_object_fk
 			references acs_objects on delete cascade,
-  action                varchar(100) default '' not null,
-  action_pretty         text default '' not null,
-  msg    		text default '' not null
+  action                varchar(100),
+  action_pretty         text,
+  msg    		text
 );
 
 create index journal_entries_object_idx on journal_entries (object_id);
@@ -113,8 +113,8 @@
         insert into journal_entries (
             journal_id, object_id, action, action_pretty, msg
         ) values (
-            v_journal_id, new__object_id, coalesce(new__action,''''), 
-            coalesce(new__action_pretty,''''), coalesce(new__msg,'''')
+            v_journal_id, new__object_id, new__action, 
+            new__action_pretty, new__msg
         );
 
         return v_journal_id;
