Re: Proposal "stack trace" like debugging option in PostgreSQL

From: Edson Richter <edsonrichter(at)hotmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Proposal "stack trace" like debugging option in PostgreSQL
Date: 2016-07-31 20:32:02
Message-ID: COL131-W26B28C1A1AAE54C5147B44CF030@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> From: tgl(at)sss(dot)pgh(dot)pa(dot)us
> To: edsonrichter(at)hotmail(dot)com
> CC: pgsql-general(at)postgresql(dot)org
> Subject: Re: [GENERAL] Proposal "stack trace" like debugging option in PostgreSQL
> Date: Sun, 31 Jul 2016 11:56:11 -0400
>
> Edson Richter <edsonrichter(at)hotmail(dot)com> writes:
> > But in production this is not possible, and I would to propose a feature
> > that has less impact over production then a debug extension: a
> > stacktrace of calls.
>
> > Simular to Java stack traces, but disabled by default. When enabled, In
> > case of an event like "duplicate key" (or a function raise exception) or
> > other similar problems that wont allow the database to execute the SQL
> > command,the strack trace will bring the complete list of function call.
>
> Uh, doesn't the CONTEXT field of error messages give you that already?
>
> regards, tom lane

Would you give me an example where I can get the info you mention above? Do I need to enable some kind of parameter to get this context field?
I usually receive and error saying something about the duplicate key (or FK violation, or Check Constraint), but not the function (triggers) call chain that lead to that error.
Regards,
Edson Richter

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Patrick B 2016-07-31 22:11:43 pg_archivecleanup standalone bash script
Previous Message Adrian Klaver 2016-07-31 20:31:12 Re: Proposal "stack trace" like debugging option in PostgreSQL