On 2020-Jan-21, MBeena Emerson wrote: > The usage of the function errtableconstraint seems only to set the > schema_name table_name constraint_name internally and not for display > purposes. As seen in the following two cases where the relation name is > displayed using RelationGetRelationName and errtableconstraint is called as > part of errcode parameter not errmsg.
You can see those fields by raising the log verbosity; it's a client-side thing. For example, in psql you can use \set VERBOSITY verbose In psql you can also use \errverbose after an error to print those fields. -- Álvaro Herrera https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services