Re: [Gnumed-devel] Can't bootstrap gnumed again

[Carlos Moro]

Hi,

As Karsten commented (I also found that problem yesterday), this patch 
might solve the problem...

Best regards,
carlos

Index: gmMeasurements.sql
===================================================================
RCS file: /cvsroot/gnumed/gnumed/gnumed/server/sql/gmMeasurements.sql,v
retrieving revision 1.42
diff -u -r1.42 gmMeasurements.sql
--- gmMeasurements.sql  14 May 2005 15:04:39 -0000      1.42
+++ gmMeasurements.sql  18 May 2005 12:32:17 -0000
@@ -259,7 +259,7 @@
 alter table test_result alter column soap_cat set default 'o';
 alter table test_result add constraint numval_needs_unit
        check (
-               ((val_num is not null) and (trim(coalesce(val_unit, '') != '')))
+               ((val_num is not null) and (trim(coalesce(val_unit, '')) != ''))
                        or
                (val_num is null)
        );