What do the different SQL error codes emitted by Heroku Postgres mean?

Issue

You have observed some SQL error codes (in the format of sql_error_code = XXXXX) emitted in the logs of Heroku Postgres, and are not sure what they mean.

Resolution

Postgres emits error codes for all operations, including successful operations, that follow the SQLSTATE conventions as part of the SQL standard.

The most common emitted error code is 00000, meaning "successful completion". This is equivalent to an INFO log level. Detailed information on all the error codes can be found here: https://www.postgresql.org/docs/current/static/errcodes-appendix.html

Ask on Stack Overflow

Engage with a community of passionate experts to get the answers you need

Ask on Stack Overflow

Heroku Support

Create a support ticket and our support experts will get back to you

Contact Heroku Support