Logging parameters
Posted: 14.03.2014, 13:53
Hi, I'm using Zeos 7.0.3 Stable and TZSqlMonitor, and found update queries with parameters are logged twice, first using "$N" (where N is the param number) then using "?", for example:
Note that I've added miliseconds to the query, to let you note the different moments both queries are done.
Apart from that, is there a way to also log the parameter itself?, I mean replacing the $ and ? with its value.
Code: Select all
2014-03-14 09:48:36:430 cat: Prepare, proto: postgresql-8, msg: PREPARE 'update paciente set IdPaciente=$1, NroFcr=$2, Protesisortesis=$3, Alergias=$4, ApellidoPaterno=$5, ApellidoMaterno=$6, IdTipoDocumento=$7, NroDocumento=$8, Nombres=$9, FechaNacimiento=$10, IdSexo=$11, Domicilio=$12, Telefono=$13, IdLocalidad=$14, IdDepartamento=$15, IdProvincia=$16, IdEstadoCivil=$17, IdEtnia=$18, IdReligion=$19 where(idpaciente = $20)'
2014-03-14 09:48:36:861 cat: Execute prepared, proto: postgresql-8, msg: update paciente set IdPaciente=?, NroFcr=?, Protesisortesis=?, Alergias=?, ApellidoPaterno=?, ApellidoMaterno=?, IdTipoDocumento=?, NroDocumento=?, Nombres=?, FechaNacimiento=?, IdSexo=?, Domicilio=?, Telefono=?, IdLocalidad=?, IdDepartamento=?, IdProvincia=?, IdEstadoCivil=?, IdEtnia=?, IdReligion=? where(idpaciente = ?)Apart from that, is there a way to also log the parameter itself?, I mean replacing the $ and ? with its value.