Re: [Gnumed-devel] where the script is crashing

[Karsten Hilbert]

On Tue, Jan 10, 2006 at 11:53:23AM +1100, Richard wrote:

> Looks like it is crashing in this function,
No, it doesn't. The error is said to occur in line 35. Which
contains a "drop index ... on ..." statement. And the error
complains about the "on" part. Removing that (on second
thought it's not needed) will make the index dropping work.
Which will make the index creation directly following that
line work, too. Fixed.

Since you have given only a brief snippet of the log we
cannot determine whether something's wrong with the
function, too. Surely this :

> create function i18n.set_curr_lang(text, name)
>         returns unknown
>         language 'plpgsql'
>         security definer
>         as '
> DECLARE
>         _lang ALIAS FOR $1;
> it 
  ^^

does not exist in my script.

Karsten
-- 
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346