[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Gnumed-devel] Can't bootstrap gnumed again
From: |
Carlos Moro |
Subject: |
Re: [Gnumed-devel] Can't bootstrap gnumed again |
Date: |
Wed, 18 May 2005 14:33:56 +0200 |
User-agent: |
Mozilla Thunderbird 1.0.2 (X11/20050317) |
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)
);