Hi all
I'm seeing enough questions on pgsql-general and stack overflow to
suggest that the docs for how sequences interact with transaction
rollback. Take the most recent post on -general, where the person read
at least the tutorial, but had no idea about the exemption.
The attached patch:
- Moves the note about nextval() from the footer to be inside the
nextval description
- Adds an xref from the advanced-transactions tutorial where the poster
noted their point of confusion, noting the exemption and pointing to the
docs on nextval.
- A pointer from the docs on SERIAL types to the nextval notes on tx
rollback.
Comments would be appreciated.
--
Craig Ringer