Craig Ringer <ringerc@ringerc.id.au> wrote:
> I'm seeing enough questions on pgsql-general and stack overflow
> to suggest that the docs for how sequences interact with
> transaction rollback.
Yeah, I've noticed a surprising number of people who are being
surprised by the non-transactional nature of sequences (and serial
columns) in spite of current caveats in the docs; so I agree that we
should punch that up in the docs a bit.
> 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.
I haven't reviewed it in detail but noticed an apparent editing
error: "which are used the counters" should probably have an "as"
thrown in there. Or something.
-Kevin