composite_type_mismatch

Reading a composite value whose row type was altered in an incompatible way after the value was created normally causes PostgreSQL to report an error. This parameter controls that behavior. With the default, error, an error is reported, aborting the current transaction. With warn, the system warns about mismatches but allows execution to continue. With disabled, the check is not performed at all. Settings other than error may cause crashes, wrong results, or other serious problems. Only superusers and users with the appropriate SET privilege can change this setting.

English manual coverage begins with PostgreSQL 7.4. Source history and runtime observations have their own recorded version boundaries.

Reading PG 18·Select a recorded version

14 15 16 17 18 19

boot val: error
carried from: Unknown
carry reason: Unknown
category: Developer Options
category zh: 开发者选项
context: superuser
doc same as: Unknown
documented: true
enumvals: error, warn, disabled
extra desc: Unknown
human: error
lang: en
max val: Unknown
metadata version: 18.7
min val: Unknown
minimum minor: 18.7
name: composite_type_mismatch
runtime verified: false
setting: Unknown
short desc: Sets how version mismatches of composite values are handled.
source: verified-release-source-and-manual
source evidence: map[file:src/backend/utils/misc/guc_tables.c release:18.7 sha256:a234f611380b4ac8c45a685257f138cb4fa08e5fc3cdb59f686b90b7b858fa7c]
unit: Unknown
vartype: enum

Definition PG 18

Reading a composite value whose row type was altered in an incompatible way after the value was created normally causes PostgreSQL to report an error. This parameter controls that behavior. With the default, error, an error is reported, aborting the current transaction. With warn, the system warns about mismatches but allows execution to continue. With disabled, the check is not performed at all.

Settings other than error may cause crashes, wrong results, or other serious problems. Only superusers and users with the appropriate SET privilege can change this setting.

Compare versions

Complete source facts

doc html

<p>
        Reading a composite value whose row type was altered in an
        incompatible way after the value was created normally causes
        <span class="productname">PostgreSQL</span> to report an error.
        This parameter controls that behavior.  With the default,
        <code class="literal">error</code>, an error is reported, aborting the current
        transaction.  With <code class="literal">warn</code>, the system warns about
        mismatches but allows execution to continue.  With
        <code class="literal">disabled</code>, the check is not performed at all.
       </p><p>
        Settings other than <code class="literal">error</code> may <span class="emphasis"><em>cause
        crashes, wrong results, or other serious problems</em></span>.
        Only superusers and users with the appropriate <code class="literal">SET</code>
        privilege can change this setting.
       </p>

documentation revision

{"inputs":[{"file":"runtime-config-developer.html","kind":"same-version-reviewed-manual","locale":"en","sha256":"a3f6a107ed6ba4edaf6df03e52f4a469bd09350d545e4ff419e62844025ec1cf","version":"18.7"},{"file":"runtime-config-developer.html","kind":"same-version-reviewed-manual","locale":"zh-Hans","sha256":"e7e22aa5738a1d376b84af1adca796c5e14746266733f925eb50c3ef86a50655","version":"18.7"}],"release":"18.7","runtime_remeasured":false,"source_revision":"pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552"}

Source references

Original manual reference

Full definition and evidence JSON

Definition sources

center · PostgreSQL 18 · docs-refresh-20261113:release-source

Text language: en · docs-refresh-20261113:release-source