Re: how to emit line number in a function? - Mailing list pgsql-general

From Richard Huxton
Subject Re: how to emit line number in a function?
Date
Msg-id 436A42EC.1060609@archonet.com
Whole thread Raw
In response to how to emit line number in a function?  (Bricklen Anderson <BAnderson@PresiNET.com>)
Responses Re: how to emit line number in a function?  (Bricklen Anderson <BAnderson@PresiNET.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: SCassidy@overlandstorage.com
Date:
Subject: Re: Changing ids conflicting with serial values?
Next
From: Richard Huxton
Date:
Subject: Re: Querying for related tables