Re: timed messages

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: timed messages
Дата
Msg-id CAKFQuwbwvJq3e-qJxB01=S9oYB+uz3efj0d5VeYYPMkF+dPuZQ@mail.gmail.com
обсуждение исходный текст
Ответ на timed messages  (PG Doc comments form <noreply@postgresql.org>)
Список pgsql-docs
On Mon, Nov 16, 2020 at 2:08 PM PG Doc comments form <noreply@postgresql.org> wrote:
The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/13/plpgsql-errors-and-messages.html
Description:

Please add an example how to format messages, that they will contain
timestamp.

The only thing the format string gives you is the ability to specify % in a location and supply the content to print in that location via the optional expression list.  If you want to print a timestamp you would need to set it up yourself, probably using to_char(timestamp) as an expression.

Ideally through global/session configuration format for raise
messages.


That isn't a thing in PostgreSQL.

You can set up a log file line format that includes such things, but the raw message content for RAISED is no more or less than what you either type literally or it computes from format+expressions.

David J.

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

Предыдущее
От: PG Doc comments form
Дата:
Сообщение: timed messages
Следующее
От: Fujii Masao
Дата:
Сообщение: Re: Documentation of return values of range functions lower and upper