Craig Ringer <ring...@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
-- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers