From: | Bricklen Anderson <BAnderson(at)PresiNET(dot)com> |
---|---|
To: | Richard Huxton <dev(at)archonet(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: how to emit line number in a function? |
Date: | 2005-11-03 17:25:27 |
Message-ID: | 436A4807.7080308@PresiNET.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Richard Huxton wrote:
> 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.
>
Okay, thanks for the head's up.
Is there any other way to get the current line number, for example, an inline
function call to elog(?) or something? It's not a huge deal, but it would be
useful for debugging and timings.
--
_______________________________
This e-mail may be privileged and/or confidential, and the sender does
not waive any related rights and obligations. Any distribution, use or
copying of this e-mail or the information it contains by other than an
intended recipient is unauthorized. If you received this e-mail in
error, please advise me (by return e-mail or otherwise) immediately.
_______________________________
From | Date | Subject | |
---|---|---|---|
Next Message | Csaba Nagy | 2005-11-03 17:46:47 | Re: Changing ids conflicting with serial values? |
Previous Message | Richard Huxton | 2005-11-03 17:10:44 | Re: Querying for related tables |