Re: Call stacks and RAISE INFO - Mailing list pgsql-hackers

From Josh Berkus
Subject Re: Call stacks and RAISE INFO
Date
Msg-id 4E99F4DF.8080708@agliodbs.com
Whole thread Raw
In response to Re: Call stacks and RAISE INFO  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
> No, I don't think so.  The use-case for this sort of thing seems to me
> to be messages that are directed to the user or DBA, and don't want to
> be decorated with a lot of information about where they came from.
> That determination is usually pretty clear when you write the code.

For my case, I agree with Tom.  For example, in my recent debugging
session, I was debugging a recursive function ... one which calls
itself, up to 6 levels deep.  For that function, I want to turn context
off because there's so much it becomes unreadable, and instead I put a
nesting counter in the INFO.

I don't want to turn of context for other functions universally -- even
in the same ETL session -- because I want to know what called them,
since some of them can be called on multiple paths.

-- 
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Pushing ScalarArrayOpExpr support into the btree index AM
Next
From: Jeff Janes
Date:
Subject: Re: index-only scans