Bricklen Anderson wrote:
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?
I don't think you can do so yourself. However, recent versions of PG should display the line number of a RAISE NOTICE or similar if you have the error verbosity high enough.
-- Richard Huxton Archonet Ltd ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend