[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Gnumed-devel] errors - going backwards
From: |
Karsten Hilbert |
Subject: |
Re: [Gnumed-devel] errors - going backwards |
Date: |
Thu, 8 Dec 2005 17:11:03 +0100 |
User-agent: |
Mutt/1.5.11 |
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
- Re: [Gnumed-devel] GNUmed brochures (was When will GNUmed be ready), (continued)
- Re: [Gnumed-devel] GNUmed brochures (was When will GNUmed be ready), Karsten Hilbert, 2005/12/14
- Message not available
- Re: [Gnumed-devel] GNUmed brochures (was When will GNUmed be ready), Karsten Hilbert, 2005/12/14
- Re: [Gnumed-devel] When will GNUmed be ready (was Eureka! - ?found the error gnuMed running now), Sebastian Hilbert, 2005/12/09
- Re: [Gnumed-devel] When will GNUmed be ready (was Eureka! - ?found the error gnuMed running now), Karsten Hilbert, 2005/12/09
- Re: [Gnumed-devel] Eureka! - ?found the error gnuMed running now, Karsten Hilbert, 2005/12/09
Re: [Gnumed-devel] Eureka! - ?found the error gnuMed running now, Karsten Hilbert, 2005/12/08
Re: [Gnumed-devel] errors - going backwards,
Karsten Hilbert <=