|
From: | catmat |
Subject: | [Gnumed-devel] may help |
Date: | Sat, 04 Dec 2004 22:53:41 +1100 |
User-agent: | Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.7.3) Gecko/20040913 |
ERROR: null value in column "fk_encounter" violates not-null constraintCONTEXT: 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 queryclin_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';
[Prev in Thread] | Current Thread | [Next in Thread] |