Hi Didier,
I imagine that this is the sql executed from a trigger.
Could you provide the trigger pl/pgsql code ?
as the source and target tables (anonymized) definition ?
After a fresh db restart, are thoses logs the same for the 6 first
executions and the following ones ?
Regards
PAscal
--
Hi Tom
Thanks a lot for your answer.
*) Here is information about my server :
[postgres@noeyypvd pg_log]$ cat /etc/redhat-release
Red Hat Enterprise Linux Server release 7.3 (Maipo)
postgres=# select version() ;
version
---
ROS Didier writes:
> postgres=# show log_error_verbosity ;
> log_error_verbosity
> -
> default
> (1 row)
So ... how old is this server? AFAIK the above should be enough to ensure
you get the DETAIL lines with parameter values. But the ability to log
those hasn't been there
ROS Didier wrote:
> Here is a biggest part of my log file :
>
> 2019-02-27 14:41:28 CET [16239]: [5696-1] [10086]
> user=pgbd_preint_sg2,db=pgbd_preint_sg2,client=localhost.localdomainLOG:
> duration: 1.604 ms
> 2019-02-27 14:41:28 CET [16239]: [5697-1] [10086]
> user=pgbd_preint_sg2,db=pgbd_
