Re: verbose mode for pg_input_error_message?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: verbose mode for pg_input_error_message?
Дата
Msg-id 1430967.1672674282@sss.pgh.pa.us
обсуждение исходный текст
Ответ на verbose mode for pg_input_error_message?  (Andrew Dunstan <andrew@dunslane.net>)
Ответы Re: verbose mode for pg_input_error_message?  (Andrew Dunstan <andrew@dunslane.net>)
Список pgsql-hackers
Andrew Dunstan <andrew@dunslane.net> writes:
> I've been wondering if it might be a good idea to have a third parameter
> for pg_input_error_message() which would default to false, but which if
> true would cause it to emit the detail and hint fields, if any, as well
> as the message field from the error_data.

I don't think that just concatenating those strings would make for a
pleasant API.  More sensible, perhaps, to have a separate function
that returns a record.  Or we could redefine the existing function
that way, but I suspect that "just the primary error" will be a
principal use-case.

Being able to get the SQLSTATE is likely to be interesting too.

            regards, tom lane



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Justin Pryzby
Дата:
Сообщение: Re: Allow placeholders in ALTER ROLE w/o superuser
Следующее
От: Tom Lane
Дата:
Сообщение: Re: CAST(... ON DEFAULT) - WIP build on top of Error-Safe User Functions