Proposal "stack trace" like debugging option in PostgreSQL - Mailing list pgsql-general

From Edson Richter
Subject Proposal "stack trace" like debugging option in PostgreSQL
Date
Msg-id BLU437-SMTP58D2A967A6074E4FD1A21CF020@phx.gbl
Whole thread Raw
Responses Re: Proposal "stack trace" like debugging option in PostgreSQL  (Adrian Klaver <adrian.klaver@aklaver.com>)
Re: Proposal "stack trace" like debugging option in PostgreSQL  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Dear community,


Sorry if this is not the right place for proposing new features. Also,
sorry if I'm proposing something already existing.

I do currently use the "debug" extension to better understand the
entrophy of my application regarding database.

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.

This would help to track down problems that escaped the development and
test environments, and reached the production systems.


If this feature already exists, please kindly point me to the docs. If
not, please consider adding this in a future release.


Thanks,


--
Atenciosamente,

Edson Carlos Ericksson Richter



pgsql-general by date:

Previous
From: Branden Visser
Date:
Subject: Query planner using hash join when merge join seems orders of magnitude faster
Next
From: Stephen Frost
Date:
Subject: Re: restore a specific schema from physical backup