On Aug 11, 2007, at 5:20 AM, Andy Hird wrote:
> >> now, if theres a reason you can't have a primary key on >> account_stuff.account_id, id be interested to hear what that is. > > Unfortunately the main reason is that the example tables were modelled > on a 9 year old legacy Oracle db which is what I really want to use > sqlalchemy with. > > The table which account_stuff is representing has in the order of 18 > million rows so making any modifications to it, and we only have > Oracle Standard edition, would be too expensive (in time) because the > db has to be up 24/7. > > I guess there is no way of making sqlalchemy thinking that > account_stuff.account_id is a PK (equivalent) is there? I guess I > could start digging around the underlying code to see if I can > convince it! just place the "primary_key=True" attribute on your Column. since its an existing table in your oracle database, you arent creating the table there so nothing changes. --~--~---------~--~----~------------~-------~--~----~ 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 [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---