Re: How to get the content of Bind variables

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_preint_sg2,client=localhost.localdomainLOG: duration: 0.084 ms parse <unnamed>: update t_shared_liste_valeurs set deletion_date=$1, deletion_login=$2, modification_date=$3, modification_login=$4, administrable=$5, libelle=$6, niveau=$7 where code=$8
> 2019-02-27 14:41:28 CET [16239]: [5698-1] [10086] user=pgbd_preint_sg2,db=pgbd_preint_sg2,client=localhost.localdomainLOG: plan:
> 2019-02-27 14:41:28 CET [16239]: [5699-1] [10086] user=pgbd_preint_sg2,db=pgbd_preint_sg2,client=localhost.localdomainSTATEMENT: update t_shared_liste_valeurs set deletion_date=$1, deletion_login=$2, modification_date=$3, modification_login=$4, administrable=$5, libelle=$6, niveau=$7 where code=$8
> 2019-02-27 14:41:28 CET [16239]: [5700-1] [10086] user=pgbd_preint_sg2,db=pgbd_preint_sg2,client=localhost.localdomainLOG: duration: 0.288 ms bind <unnamed>: update t_shared_liste_valeurs set deletion_date=$1, deletion_login=$2, modification_date=$3, modification_login=$4, administrable=$5, libelle=$6, niveau=$7 where code=$8
> 2019-02-27 14:41:28 CET [16239]: [5701-1] [10086] user=pgbd_preint_sg2,db=pgbd_preint_sg2,client=localhost.localdomainLOG: execute <unnamed>: update t_shared_liste_valeurs set deletion_date=$1, deletion_login=$2, modification_date=$3, modification_login=$4, administrable=$5, libelle=$6, niveau=$7 where code=$8
> <<
> The statement has been executed
> It is the same problem for all the statements.
> I can not get the content of the bind variables.

You should set "log_error_verbosity" back from "terse" to "default".
Then you will see the DETAIL messages.

Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com