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 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
