Index: openacs-4/packages/acs-object-management/sql/postgresql/acs-kernel-changes-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-object-management/sql/postgresql/Attic/acs-kernel-changes-create.sql,v
diff -u -r1.4 -r1.5
--- openacs-4/packages/acs-object-management/sql/postgresql/acs-kernel-changes-create.sql	11 Dec 2009 00:19:09 -0000	1.4
+++ openacs-4/packages/acs-object-management/sql/postgresql/acs-kernel-changes-create.sql	13 Dec 2009 21:12:10 -0000	1.5
@@ -5,24 +5,24 @@
 
 insert into acs_datatypes
   (datatype, database_type)
-values
-  ('richtext', 'text');
+(select 'richtext', 'text' from dual
+  where not exists (select 1 from acs_datatypes where datatype = 'richtext'));
 
 insert into acs_datatypes
   (datatype, database_type, column_size)
-values
-  ('filename', 'varchar', '100');
+(select 'filename', 'varchar', '100' from dual
+  where not exists (select 1 from acs_datatypes where datatype = 'filename'));
 
 insert into acs_datatypes
   (datatype, database_type)
-values
-  ('float', 'float8');
+(select 'float', 'float8' from dual
+  where not exists (select 1 from acs_datatypes where datatype = 'float'));
 
 -- PG 8.x has no unsigned integer datatype
 insert into acs_datatypes
   (datatype, database_type)
-values
-  ('naturalnum', 'integer');
+(select 'naturalnum', 'integer' from dual
+  where not exists (select 1 from acs_datatypes where datatype = 'naturalnum'));
 
 
 -- Making user and person dynamic can lead to a broken web site, so