Bricklen Anderson <BAnderson@presinet.com> writes:
> I couldn't find any useful references in the docs or archives for emitting the
> line number of a plpgsql function (in a RAISE statement). I'd like to use it for
> debugging some complex functions.
> Does anyone have any tips on where to look, or an example of this?
Have a look at the m4 macro processor
changequote({,})dnl
define({func_body},{$$begin
raise exception 'I barfed on line #__line__';
end$$})dnl
create function some_func()
returns whatever
as func_body
language plpgsql;
This can be useful sometimes... but may ADD to your debugging
headaches if not used artfully!
HTH
--
-------------------------------------------------------------------------------
Jerry Sievers 305 854-3001 (home) WWW ECommerce Consultant
305 321-1144 (mobile http://www.JerrySievers.com/