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 chick...@gmail.com On Mon, Feb 22, 2010 at 11:01 AM, Michael Bayer <mike...@zzzcomputing.com>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 sqlalch...@googlegroups.com. > > To unsubscribe from this group, send email to > sqlalchemy+unsubscr...@googlegroups.com<sqlalchemy%2bunsubscr...@googlegroups.com> > . > > 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 sqlalch...@googlegroups.com. > To unsubscribe from this group, send email to > sqlalchemy+unsubscr...@googlegroups.com<sqlalchemy%2bunsubscr...@googlegroups.com> > . > 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 sqlalch...@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.
