pg.ddx.io  pgsql-docs@postgresql.org mailing list archive  

help / color / mirror / Atom feed

timed messages
2+ messages / 2 participants
[nested] [flat]

* timed messages
@ 2020-11-16 20:05 PG Doc comments form <noreply@postgresql.org>
  2020-11-16 22:00 ` Re: timed messages David G. Johnston <david.g.johnston@gmail.com>
  0 siblings, 1 reply; 2+ messages in thread

From: PG Doc comments form @ 2020-11-16 20:05 UTC (permalink / raw)
  To: pgsql-docs@lists.postgresql.org; +Cc: hans@matfyz.cz

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. Ideally through global/session configuration format for raise
messages.
Thank you in advance.


^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: timed messages
  2020-11-16 20:05 timed messages PG Doc comments form <noreply@postgresql.org>
@ 2020-11-16 22:00 ` David G. Johnston <david.g.johnston@gmail.com>
  0 siblings, 0 replies; 2+ messages in thread

From: David G. Johnston @ 2020-11-16 22:00 UTC (permalink / raw)
  To: hans@matfyz.cz, Pg Docs <pgsql-docs@lists.postgresql.org>

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.

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2020-11-16 22:00 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2020-11-16 20:05 timed messages PG Doc comments form <noreply@postgresql.org>
2020-11-16 22:00 ` David G. Johnston <david.g.johnston@gmail.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox