Hi Noel, It is, of course. I just figured that there might be some potential of introducing more compatibility with other databases, if this is a low-hanging fruit, implementation-wise.
Cheers Lukas 2013/5/13 Noel Grandin <[email protected]> > The ALTER TABLE variant looks like it's more generally useful than the > TRUNCATE version. > > > On 2013-05-10 12:57, Lukas Eder wrote: > >> Hello, >> >> This is a minor feature request: Add support for the RESTART IDENTITY / >> CONTINUE IDENTITY options that can be passed to a TRUNCATE statement in >> some databases, specifically Postgres [1] and HSQLDB [2]. >> >> The H2 roadmap already features Postgres' CASCADE option, but I think >> IDENTITY handling might be easier to implement. In fact, RESTART IDENTITY >> could be a short-hand for executing two consecutive SQL statements: >> >> 1. The TRUNCATE statement >> 2. An ALTER TABLE [table] ALTER COLUMN [column] RESTART WITH [initial >> value] >> >> Cheers >> Lukas >> >> [1]: >> http://www.postgresql.org/**docs/9.2/static/sql-truncate.**html<http://www.postgresql.org/docs/9.2/static/sql-truncate.html> >> [2]: http://hsqldb.org/doc/guide/**dataaccess-chapt.html#dac_** >> truncate_statement<http://hsqldb.org/doc/guide/dataaccess-chapt.html#dac_truncate_statement> >> -- >> You received this message because you are subscribed to the Google Groups >> "H2 Database" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to >> h2-database+unsubscribe@**googlegroups.com<h2-database%[email protected]> >> . >> To post to this group, send email to [email protected]. >> Visit this group at >> http://groups.google.com/**group/h2-database?hl=en<http://groups.google.com/group/h2-database?hl=en> >> . >> For more options, visit >> https://groups.google.com/**groups/opt_out<https://groups.google.com/groups/opt_out> >> . >> >> >> > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
