Ed Leafe wrote: > On Aug 23, 2007, at 5:02 PM, johnf wrote: > >> I have a parent and several child waiting to be saved. >> isTransactionManager = True >> >> parent is inserted into the DB >> >> then getLastInsertID() is called because the children need the PKID >> of the >> parent >> >> But no commit has occurred. >> >> getLastInsertID() fails because of no commit. >> >> I don't think this can work? Anybody have a suggestion on how I >> might fix >> this? > > Is there any other way to query the value without committing? If > not, you should probably use sequence instead, and pre-fetch it using > the dbPostgreSQL.pregenPK() method (which doesn't exist yet). >
If this is a isolation level problem, you might be right with your guess. Someone with a installed postgresql db should do a test to find out. These kind of things might work quite differently between the various database implementations. _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev Searchable Archives: http://leafe.com/archives/search/dabo-dev This message: http://leafe.com/archives/byMID/dabo-dev/[EMAIL PROTECTED]
