Hi Greg
On 11.07.24 18:09, Greg Sabino Mullane wrote:
> Thanks for the review. Please find attached a new version with proper
> tabs and indenting.
>
> Cheers,
> Greg
>
I'm testing this new log prefix and I'm wondering whether the following
behaviour is expected. The value of '%L' is different in the following
cases:
postgres=# SHOW log_line_prefix;
log_line_prefix
-----------------
%m [%p] -> %L
(1 row)
--
postgres=# SELECT 1/0;
2024-11-18 16:00:42.720 CET [3135117] -> 192.168.178.27 ERROR: division
by zero
2024-11-18 16:00:42.720 CET [3135117] -> 192.168.178.27 STATEMENT:
SELECT 1/0;
--
postgres=# SELECT pg_reload_conf();
2024-11-18 16:01:23.273 CET [3114980] -> [local] LOG: received SIGHUP,
reloading configuration files
--
postgres=# CHECKPOINT;
2024-11-18 16:01:46.758 CET [3114981] -> [local] LOG: checkpoint
starting: immediate force wait
2024-11-18 16:01:46.769 CET [3114981] -> [local] LOG: checkpoint
complete: wrote 0 buffers (0.0%), wrote 0 SLRU buffers; 0 WAL file(s)
added, 0 removed, 0 recycled; write=0.001 s, sync=0.001 s, total=0.012
s; sync files=0, longest=0.000 s, average=0.000 s; distance=0 kB,
estimate=25924 kB; lsn=0/26166430, redo lsn=0/261663D8
Is it supposed to be like this?
Thanks for the patch!
--
Jim