[sqlalchemy] Re: insert() on compound key-how to auto number second key

2007-09-08 Thread Marco Mariani
Lukasz Szybalski ha scritto: I am trying to insert a record with a compound primary key that consists of Team_Sid, User_Sid I can either do i = users_table.insert() i.execute(TEAM_SID=343, USER_SID=1,TEAM_NAME='the team') i.execute(TEAM_SID=343, USER_SID=2,TEAM_NAME='the team')

[sqlalchemy] Re: insert() on compound key-how to auto number second key

2007-09-08 Thread Lloyd Kvam
On Sat, 2007-09-08 at 10:40 +0200, Marco Mariani wrote: Your post begs for a question, which is why? :-) You are fighthing the system. Having an autonumber column as part of a compound key does not make a lot of sense. I don't think you have a really, really, really strange use case that