Re: [Gnumed-devel] errors - going backwards

[Karsten Hilbert]

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:address@hidden): 
> ../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