Okay, thanks. I had read that but interpreted it as sqlite_autoincrement=True was a workaround for this issue. Guess I'll switch to MySQL :)
-- Clayton Hicklin [email protected] On Mon, Feb 22, 2010 at 11:01 AM, Michael Bayer <[email protected]>wrote: > some details here: > > > http://www.sqlalchemy.org/docs/reference/dialects/sqlite.html#auto-incrementing-beahvior > > basically SQLite can't autoincrement with a composite PK. > > > On Feb 22, 2010, at 11:40 AM, chicklin wrote: > > > I'm using sqlite and defining my tables using declaritive_base and I > > have a composite primary key on one table. I need to specify that one > > of the columns (an Integer) generate the id's automatically. > > autoincrement=True does not work for sqlite and I don't know where to > > define sqlite_autoincrement=True when using declaritive_base. All the > > examples and documentation show it as an argument to Table(). Any > > ideas? Thanks in advance. > > > >>>> sqlalchemy.__version__ > > '0.6beta1' > > > > -- > > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > > To post to this group, send email to [email protected]. > > To unsubscribe from this group, send email to > [email protected]<sqlalchemy%[email protected]> > . > > For more options, visit this group at > http://groups.google.com/group/sqlalchemy?hl=en. > > > > -- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]<sqlalchemy%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/sqlalchemy?hl=en. > > -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. 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/sqlalchemy?hl=en.
