ts it as
a RESTART in 8.3 version and below.
2010/9/7 Bruce Momjian
> Alexsander Rosa wrote:
> > What about the risk of using ALTER SEQUENCE ... START N in a mixed
> > environment? In the 8.4.x servers it will work as designed but in the
> 8.3.x
> > (and below) servers, i
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
> Alexsander Rosa wrote:
> > Well, if it's not going to be fixed, the
What about the risk of using ALTER SEQUENCE ... START N in a mixed
environment? In the 8.4.x servers it will work as designed but in the 8.3.x
(and below) servers, instead of issuing an error it will CORRUPT the
sequence value without notice. I understand the point of keeping a
(mis)feature when it
-- Forwarded message --
From: Alexsander Rosa
Date: 2010/8/27
Subject: Re: [BUGS] BUG #5629: ALTER SEQUENCE foo START execute a RESTART
To: Tom Lane
Let me get this straight: in version 8.3 the ALTER SEQUENCE command has an
*undocumented* [1] clause START that is actually an
Then the docs are misleading:
http://www.postgresql.org/docs/8.3/static/sql-altersequence.html
According the docs, 8.3 does NOT have a START clause -- only RESTART. I
think a START clause should raise an error at 8.3 servers; there's a chance
of someone run the command in several servers (like a p
