Re: Determine the name of the calling function

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jack Kaufman <jack(dot)kaufman(at)sanmina(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Determine the name of the calling function
Date: 2013-01-31 01:17:21
Message-ID: 10554.1359595041@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

I wrote:
> Curiously, the behavior doesn't seem to be totally consistent --- when I
> run the same case again, I get an additional line of context:

> regression=# select f2();
> NOTICE: SQL statement "SELECT 1/0"
> PL/pgSQL function f1() line 5 at assignment
> PL/pgSQL function f2() line 3 at RETURN
> CONTEXT: PL/pgSQL function f2() line 3 at RETURN
> f2
> ----
> 0
> (1 row)

> That seems like a bug ...

FYI, a fix for this has been committed and will be in 9.2.3.
The code will now consistently include that first line of context.

regards, tom lane

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2013-01-31 17:25:03 Re: to_timestamp behaviour
Previous Message Steve Crawford 2013-01-30 22:39:06 Re: to_timestamp behaviour