At 8.4 release notes, item "E.5.3.3.1. TRUNCATE" there's a sentence: "The start value of a sequence can be changed by ALTER SEQUENCE START WITH. "
Maybe this sentence should be copied/moved to "E.5.3.4.1. ALTER" with extra text stating that START, in previous versions, was an (unintended) alias to RESTART -- with the wording you suggested or something like that. The advise to check server_version when using this command could be mentioned, also. 2010/9/8 Bruce Momjian <br...@momjian.us> > Alexsander Rosa wrote: > > Well, if it's not going to be fixed, then at least the docs should be > > revised to warn all 8.4+ users to avoid this command and, if it's really > > needed, always check the server version before using the ALTER SEQUENCE > ... > > START command, once it has a potentially hazardous bug that interprets it > as > > a RESTART in 8.3 version and below. > > The proper place for such notification is the 8.4 release notes, which > states: > > Sequences now contain an additional 'start_value' > column (Zoltan Boszormenyi) > > This supports <command>ALTER SEQUENCE ... RESTART. > > Which means basically 8.3 didn't have a start field at all. > > This is the first complaint I have heard about it. Do you have new > wording to suggest? Perhaps: > > In previous releases, START behaved as RESTART. > > --------------------------------------------------------------------------- > > -- Atenciosamente, Alexsander da Rosa Linux User #113925
