2200G
PostgreSQLERRORNotableData ExceptionHIGH confidence
most specific type mismatch
What this means
SQLSTATE 2200G is raised in SQL/XML or typed-table contexts when the most specific type of a value does not match the expected type hierarchy. It is primarily relevant to SQL structured type hierarchies.
Why it happens
- 1In a typed table or SQL/XML operation, the value type does not conform to the declared most specific type
How to reproduce
SQL structured type mismatch in typed tables.
expected output
ERROR: most specific type mismatch
Fix
Ensure the value type matches the typed table column declaration
WHEN When working with SQL structured types.
Why this works
Review the typed table definition and ensure inserted values conform to the declared type hierarchy.
Sources
Official documentation ↗
Class 22 — Data Exception
Content generated with AI assistance and reviewed for accuracy. Found an error? hello@errcodes.dev