here's my issue...I have to map to an existing Oracle db table with 33million rows (yeah, I know). This table has no primary key and worse, nothing, and I mean nothing to uniquely identify a row (fabulous).
as a backup, I realize that I can manually issue statements to this thing via SA, but I'd really like to use it through the ORM like I am everything else. this table is a transaction table, so 99% of the time, it's only inserts. However, there is a flag on the table to indicate that it's been processed by a batch process so that flag does get updated. Is there some way I can map rowid or something as the primary key? I think it's mostly safe since we aren't using partitioned tables and since these records are effectively never deleted while the system is running, I don't have to worry about the rowid getting reassigned on me mid-transaciton. My issue is that on insert or update, I don't want SA trying to generate and/or insert into rowid for obvious reasons.... Am I on the right track, any other ideas?? -- 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.