PostgreSQL Error Codes and Status Codes From Status Code 00000 to 03000


Class 00 — Successful Completion
PostgreSQL error Code 00000 SUCCESSFUL COMPLETION successful_completion
Class 01 — Warning
PostgreSQL error Code 01000 WARNING warning
PostgreSQL error Code 0100C DYNAMIC RESULT SETS RETURNED dynamic_result_sets_returned

PostgreSQL error Code 01008 IMPLICIT ZERO BIT PADDING implicit_zero_bit_padding
PostgreSQL error Code 01003 NULL VALUE ELIMINATED IN SET FUNCTION null_value_eliminated_in_set_function
PostgreSQL error Code 01007 PRIVILEGE NOT GRANTED privilege_not_granted
PostgreSQL error Code 01006 PRIVILEGE NOT REVOKED privilege_not_revoked
PostgreSQL error Code 01004 STRING DATA RIGHT TRUNCATION string_data_right_truncation

PostgreSQL error Code 01P01 DEPRECATED FEATURE deprecated_feature
Class 02 — No Data (this is also a warning class per the SQL standard)
PostgreSQL error Code 02000 NO DATA no_data
PostgreSQL error Code 02001 NO ADDITIONAL DYNAMIC RESULT SETS RETURNED no_additional_dynamic_result_sets_returned
Class 03 — SQL Statement Not Yet Complete
PostgreSQL error Code 03000 SQL STATEMENT NOT YET COMPLETE sql_statement_not_yet_complete

Above are list of PostgreSQL Errors Codes and Status Codes or Exit Codes along with Error and Warning messages from Error 00000 to 03000 received while performing certain operation against PostgreSQL applications or related products.

What are PostgreSQL Error Messages?
All PostgreSQL messages emitted by the PostgreSQL server are assigned five-character error codes that follow the SQL standard’s conventions for “SQLSTATE” codes. According to the standard, the first two characters of an error code denote a class of errors, while the last three characters indicate a specific condition within that class. Thus, an application that does not recognize the specific error code can still be able to infer what to do from the error class.

In general, each PostgreSQL error contains the following information:
• The PostgreSQL Error Code or PostgreSQL Error Condition
• The message text. This text is usually returned with the Error code. Some messages employ word substitution, where the word substituted represents the system-replacement of a term more specific to the occurrence.
• An explanation of how the error may have occurred.

Hope this was helpful.

SQLServerF1 Team
Information about PostgreSQL Error Codes or Status Codes or Exit Codes and Error Messages on Windows, Linux Operating Systems.


Leave a Reply

Your email address will not be published. Required fields are marked *