Code review comment for lp:~nwilliams/akiban-server/seq-accum-fix
Revision history for this message
| Nathan Williams (nwilliams) wrote | # |
© 2004
Canonical Ltd.
•
Terms of use
•
Data privacy
•
Contact Launchpad Support
•
Blog
•
Careers
•
System status
•
73416ba
(Get the code!)
That is probably the simplest. Should be just a tiny parser tweak to get hat ALTER accepted I think.
Postgres is similar. For SERIAL columns, they create the table as is, create and attach sequence, restore value with a routine, and then do the table inserts. They don't do IDENTITY so the BY DEFAULT vs ALWAYS isn't an issue. If you insert values manually into them, it will get a duplicate key when the sequence comes to it.