Previously Werner F. Bruhin wrote: > > Hi Leonard, > > paniq303 wrote: > > Hello, > > > > how is the progress with this feature - how can I use it? My > > application strongly depends on AUTOINCREMENT being available. > > > > To explain: > > > > Without AUTOINCREMENT, a deleted primary key will be reassigned. > > > > As an example: three records are created, with ids 1, 2 and 3. Now the > > record with id 3 is being deleted. We create a new record, and this > > record will get id 3 again, instead of id 4. In this way, there can be > > confusion between the old and the new record with id 3. > > > It is available in SA, i.e. I use it with Firebird SQL and in my model I > just do this: > sa.Column(u'langid', sa.Integer(), > sa.Sequence('gen_language_langid'), primary_key=True, nullable=False),
Can someone explain what the differences between using a sequence like this or autoincrement=True on the column are? Wichert. -- Wichert Akkerman <wich...@wiggy.net> It is simple to make things. http://www.wiggy.net/ It is hard to make things simple. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---