please ignore this thread.
I copied the table from schema to public and the identity constraint was
lost in the process. I fixed it by executing
ALTER TABLE table_name
ALTER COLUMN column_name
INT NOT NULL IDENTITY;
ALTER TABLE table_name
ALTER COLUMN column_name
RESTART WITH 100000;
thank you.
On Monday, June 18, 2012 1:34:29 PM UTC-7, Igal wrote:
>
> hi,
>
> I migrated a database from MSSQL to H2.
>
> when I insert a record to a table with an identity column that already has
> records, I expect the new record to have the highest id, but it does not.
>
> any ideas?
>
> thanks
>
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To view this discussion on the web visit
https://groups.google.com/d/msg/h2-database/-/-diOAWpMuXMJ.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
