Re: [Gnumed-devel] [Gnumed-bugs] <bug>: on saving progress note

[Karsten Hilbert]

On Sun, Feb 03, 2013 at 08:27:45PM +0100, Karsten Hilbert wrote:

> > Check constraints:
> >     "clin_narrative_soap_cat_check" CHECK (soap_cat IS NULL OR 
> > (lower(soap_cat) = ANY (ARRAY['s'::text, 'o'::text, 'a'::text, 'p'::text])))
> 
> There we go. This should not be there.
> 
> I'll develop a patch.

You can run this in your database:

        set default_transaction_read_only to off;
        alter table clin.clin_narrative drop constraint 
clin_narrative_soap_cat_check cascade;

1.2.9 and 1.3 will automatically apply it, too.

Karsten
-- 
GPG key ID E4071346 @ gpg-keyserver.de
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346