The message output format is as follows:
Format of messages returned to an application
msgType: msgText (msgNumber)
Format of messages output to the server message log
SQLSTATE: date [processID]: [internalCode-1] user = userName,db = dbName,remote = clientIpAddress(portNumber) app = appName msgType: msgText (msgNumber)
See
Refer to "PostgreSQL Error Codes" under "Appendixes" in the PostgreSQL Documentation for information on SQLSTATE.
Note
Notes on monitoring messages output to the server message log
Use SQLSTATE to monitor server messages, noting the following:
Configuration method
Refer to "Error Log Settings" under "Setup" in the Installation and Setup Guide for Server for details.
Notes
The user name, client IP address (port number), and application name may sometimes be blank.
Multiple message numbers may be output.
Notes on monitoring messages returned to an application
You can output SQLSTATE to a message to be returned to an application. The following explains how to configure the settings for outputting SQLSTATE and gives cautions to be observed when doing so.
How to configure the settings:
In the SET statement, set the log_error_verbosity parameter to VERBOSE.
For an application that uses the C language library, use the PQsetErrorVerbosity function to set message redundancy to PQERRORS_VERBOSE.
Cautions
SQLSTATE is output only to messages to be returned to applications that use the C language library.
In some cases, userName, clientIpAddress(portNumber), and applicationName may be blank.
Multiple message numbers may be output.
If the email address "pgsql-bugs@postgresql.org" is output to the message and the cause of the error cannot be identified, contact Fujitsu technical support.
Example
Message output to the server message log
3D000: 2013-07-10 19:41:05 JST [13899]: [1-1] user = symfo,db = symfo,remote = 127.0.0.1(51902) app = [unknown] FATAL: database "symfo" does not exist (10571)
