On Fri, Sep 16, 2005 at 06:36:48PM -0400, jeff sacksteder wrote:
> ALTER SEQUENCE foo_id_seq
> RESTART WITH (SELECT max(id) FROM foo);
>
> Is this syntax correct and supported?
Not according to the documentation; for an alternative see the
example under "User Comments":
http://www.postgresql.org/docs/8.0/interactive/sql-altersequence.html
--
Michael Fuhr