The Document Number Is Reserved Before the PDF Exists

The hard part of document numbering is not incrementing an integer. It is deciding what happens when the integer is reserved, rendering starts, and the render fails. PostgreSQL sequences are built for speed. They are not built for legal numbering. A sequence advances even if the surrounding transact