Issue
Different PostgreSQL statements in my logs show sql_error_code = 00000
. Is this an error or a problem with my statements?
Resolution
These log lines do not indicate any errors with your PostgreSQL queries.
PostgreSQL's log lines that include sql_error_code = 00000
mean that the specific statement that was logged was successful. This specific sql_error_code=00000
corresponds to successful_completion
. The complete list of PostgreSQL error logs and their definitions is available at https://www.postgresql.org/docs/current/errcodes-appendix.html.
All messages emitted by PostgreSQL will include sql_error_code
with the corresponding five-character error code, even if they refer to statements that were successful.