Re: Call stacks and RAISE INFO

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Re: Call stacks and RAISE INFO
Дата
Msg-id 4E99F4DF.8080708@agliodbs.com
обсуждение исходный текст
Ответ на Re: Call stacks and RAISE INFO  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Pushing ScalarArrayOpExpr support into the btree index AM
Следующее
От: Jeff Janes
Дата:
Сообщение: Re: index-only scans