Remove error check that disallowed setval() on a sequence with cache

Tom Lane <tgl@sss.pgh.pa.us>

Commit: b44e46cfcea288c3f404b4da4456b9736b057a38
Author: Tom Lane <tgl@sss.pgh.pa.us>
Date: 2000-12-08T20:06:58Z
Releases: 7.1.1
Remove error check that disallowed setval() on a sequence with cache
value greater than one.  The behavior this sought to disallow doesn't
seem any less confusing than the other behaviors of cached sequences.
Improve wording of some error messages, too.
Update documentation accordingly.  Also add an explanation that
aborted transactions do not roll back their nextval() calls; this
seems to be a FAQ, so it ought to be mentioned here...

Files

PathChange+/−
doc/src/sgml/ref/create_sequence.sgml modified +25 −17
src/backend/commands/sequence.c modified +6 −14