Error Codes
This document describes the error codes you may encounter when working with the CloudBase PostgreSQL database.
Common SQLSTATE Error Code Reference
Here are the most frequently encountered SQLSTATE error codes:
| SQLSTATE | Error Name | Description |
|---|---|---|
| 23505 | unique_violation | Unique constraint violation |
| 23503 | foreign_key_violation | Foreign key violation |
| 23502 | not_null_violation | Not-null violation |
| 42P01 | undefined_table | Table not found |
| 42703 | undefined_column | Column not found |
| 42601 | syntax_error | SQL syntax error |
| 57014 | query_canceled | Query canceled |
Full Error Code Reference
For the complete list of PostgreSQL SQLSTATE error codes, refer to the official documentation:
💡 Tip
- When encountering an error, record the full error message (including SQLSTATE code and description)
- Use the first two characters of the SQLSTATE code to quickly identify the error category
- If you cannot resolve the issue, contact Technical Support for help