The postgres-specific sql extension 'ALTER SEQUENCE' does not appear to support subqueries.<br /><br /> I have inserted
somedata into a table, including values in the primary key. I want to reset the associated sequence so that any further
recordsto be inserted into that table resume numbering correctly. The statement I attempted was:<br /><br /> ALTER
SEQUENCEfoo_id_seq <br /> RESTART WITH (SELECT max(id) FROM foo);<br /><br /> Is this syntax correct and supported?<br
/><br/> <br />