[Gnumed-devel] may help

[catmat]

> ERROR:  null value in column "fk_encounter" violates not-null constraint
> CONTEXT:  PL/pgSQL function "trf_name_new_episode" line 12 at execute 
> statement


is this bug still active in test data? ( looks like a missing 
fk_encounter in the function)

> create function trf_name_new_episode() returns opaque as '
> declare
>         clin_narr_insert text;
> begin
>         -- generate insert query
>         clin_narr_insert := ''insert into clin_narrative (soap_cat, 
> narrative, is_episode_name, fk_episode) values (''
>                                          || '' ''''s'''',''
>                                          || '' 
> ''''by_trigger_on_insert'''',''
>                                          || '' ''''true''''::boolean, ''
>                                          || NEW.pk || '')'' ;
> --      raise notice ''%'', clin_narr_insert;
>         -- execute insert query
>         EXECUTE clin_narr_insert;
>         return NULL;
> end;
> ' language 'plpgsql';