On Thu, Dec 08, 2005 at 08:18:38AM +1100, Richard wrote: > Back to not booting demographics again with the fresh update!!!. Whoa, no !! :-((
> create function set_nickname(integer, text) returns integer as ' > DECLARE > _id_identity alias for $1; > _nick alias for $2; > _names_row record; > BEGIN ... > msg := ''Cannot set nickname ['' || _nick || '']. No active > <names> row with id_identity ['' || _id_identity || ''] found.'' ... > END;' language 'plpgsql' ... > 2005-12-08 08:16:05 [ERROR] > (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): > ../sql/gmDemographics-Person-views.sql:165: ERROR: syntax error at or near > "msg" at character 1QUERY: msg := 'Cannot set nickname [' || $1 || ']. No > active <names> row with id_identity [' || $2 || '] found.' raise exception > msgCONTEXT: SQL statement in PL/PgSQL function "set_nickname" near line 12 Aha ! While the first fix in this line was correct (it added to : to the =) there needs to be a second fix, too: msg isn't declared ! Shame upon me. Karsten -- GPG key ID E4071346 @ wwwkeys.pgp.net E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346 _______________________________________________ Gnumed-devel mailing list [email protected] http://lists.gnu.org/mailman/listinfo/gnumed-devel
