Re: how to emit line number in a function?

From: Richard Huxton <dev(at)archonet(dot)com>
To: Bricklen Anderson <BAnderson(at)presinet(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: how to emit line number in a function?
Date: 2005-11-03 17:03:40
Message-ID: 436A42EC.1060609@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2005-11-03 17:10:44 Re: Querying for related tables
Previous Message SCassidy 2005-11-03 17:02:09 Re: Changing ids conflicting with serial values?