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 _______________________________________________ Gnumed-devel mailing list [email protected] http://lists.gnu.org/mailman/listinfo/gnumed-devel
