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
[2]:
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 [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.
--
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.
