PostgreSQL error code
PostgreSQL error 54000
54000 is the SQLSTATE PostgreSQL reports for program limit exceeded, in class 54, Program Limit Exceeded.
| SQLSTATE | 54000 |
|---|---|
| Condition name | program_limit_exceeded |
| Class | 54 — Program Limit Exceeded |
Reproduce it, then fix it
PostgreSQL text can’t hold the NUL character (byte 0), which tends to arrive with data from C programs or binary files. Strip it before inserting, or store the raw bytes as bytea. Run the broken query to see the error, then switch to the fixed one. Edit either freely; every run is rolled back.
SELECT 'part' || chr(0) || 'number';
SELECT 'part' || ' ' || 'number';