log_parameter_max_length_on_error
If greater than zero, each bind parameter value reported in error messages is trimmed to this many bytes. Zero (the default) disables including bind parameters in error messages. -1 allows bind parameters to be printed in full. If this value is specified without units, it is taken as bytes. Non-zero values of this setting add overhead, as PostgreSQL will need to store textual representations of parameter values in memory at the start of each statement, whether or not an error eventually occurs. The overhead is greater when bind parameters are sent in binary form than when they are sent as text, since the former case requires data conversion while the latter only requires copying the string.
英文手册覆盖始于 PostgreSQL 7.4. 来源历史与运行验证各自保留独立版本边界。
当前阅读 PG 18·选择有来源记录的版本
此版本暂无所选语言的定义,以下显示原始英文内容。
- boot val
- 0
- category
- Reporting and Logging / What to Log
- context
- user
- documented
- true
- enumvals
- 未知
- extra desc
- -1 means log values in full.
- lang
- en
- max val
- 1073741823
- metadata version
- 18
- min val
- -1
- name
- log_parameter_max_length_on_error
- short desc
- Sets the maximum length in bytes of data logged for bind parameter values when logging statements, on error.
- source
- pg-settings-source-snapshot
- unit
- B
- vartype
- integer
版本定义 PG 18
If greater than zero, each bind parameter value reported in error messages is trimmed to this many bytes. Zero (the default) disables including bind parameters in error messages. -1 allows bind parameters to be printed in full. If this value is specified without units, it is taken as bytes. Non-zero values of this setting add overhead, as PostgreSQL will need to store textual representations of parameter values in memory at the start of each statement, whether or not an error eventually occurs. The overhead is greater when bind parameters are sent in binary form than when they are sent as text, since the former case requires data conversion while the latter only requires copying the string.
比较版本
来源引用
定义来源
center · PostgreSQL 18 · english-manuals:29452938e32975be97b86d8ed9e7b431a07b563730203b102f0033b554603a29
正文语言: en · english-manuals:29452938e32975be97b86d8ed9e7b431a07b563730203b102f0033b554603a29