Remove error check that disallowed setval() on a sequence with cache
authorTom Lane <tgl@sss.pgh.pa.us>
Fri, 8 Dec 2000 20:06:58 +0000 (20:06 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Fri, 8 Dec 2000 20:06:58 +0000 (20:06 +0000)
commiteb38381c428ec7466ad23a07a656e006a9ae0d1d
treeb002f276401b1349da71b823ba4b54c79599ade7
parent51e19c769b160f90efde56f0d7bccaa4b941decc
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...
doc/src/sgml/ref/create_sequence.sgml
src/backend/commands/sequence.c