Index: openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.3.2d1-5.3.2d2.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.3.2d1-5.3.2d2.sql,v
diff -u -N -r1.1.2.1 -r1.1.2.2
--- openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.3.2d1-5.3.2d2.sql	24 May 2007 12:16:27 -0000	1.1.2.1
+++ openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.3.2d1-5.3.2d2.sql	6 Jun 2007 12:47:46 -0000	1.1.2.2
@@ -5,7 +5,18 @@
 -- @creation-date 2007-05-24
 -- @cvs-id $Id$
 --
+create or replace function inline_0() returns integer as '
 
-alter table apm_parameters drop constraint apm_parameter_datatype_ck;
-alter table apm_parameters add constraint apm_parameter_datatype_ck check(datat\
-ype in ('number', 'string','text'));
\ No newline at end of file
+begin
+    if (select count(*) from pg_constraint where conname=''apm_parameters_datatype_ck'') > 0 then
+        alter table apm_parameters drop constraint apm_parameters_datatype_ck;
+    end if;
+    if (select count(*) from pg_constraint where conname=''apm_parameter_datatype_ck'') > 0 then
+        alter table apm_parameters drop constraint apm_parameter_datatype_ck;
+    end if;
+    alter table apm_parameters add constraint apm_parameters_datatype_ck check(datatype in (''number'', ''string'',''text''));
+    return null;
+end;' language 'plpgsql';
+
+select inline_0();
+drop function inline_0();