3B000ERRORTier 2 — Caution✅ HIGH confidencesavepoint exception
Category: Savepoint ExceptionVersions: All Postgres versions
What this means
SQLSTATE 3B000 is the generic savepoint exception code raised when a savepoint operation fails in a way that does not map to a more specific code. See also 3B001 for the invalid savepoint name variant.
Why it happens
- 1Generic savepoint operation failure not covered by a more specific code
How to reproduce
Generic savepoint error.
trigger — this will ERROR
ERROR: savepoint exception
Fix 1: Inspect the error message for the specific savepoint issue
When 3B000 appears.
fix
SELECT * FROM pg_savepoints; -- not a standard view but illustrativeWhy this works
Check the error detail and ensure savepoints are created, rolled back, and released in the correct order within the transaction.
Sources
📚 Official docs: https://www.postgresql.org/docs/current/errcodes-appendix.html
🔧 Source ref: Class 3B — Savepoint Exception
Confidence assessment
✅ HIGH confidence
Standard SQLSTATE generic savepoint error. Stable across versions.
See also
📄 Reference pages
SAVEPOINTROLLBACK TO SAVEPOINT
⚙️ This error reference was generated with AI assistance and reviewed for accuracy. Examples are provided to illustrate common scenarios and may not cover every case. Always test fixes in a development environment before applying to production. Spotted an error? Suggest a correction →