On Mon, Sep 25, 2006 at 03:16:07PM +0530, Gurjeet Singh wrote: > >All other databases I used up to now just ignore the statement violating > >the > >> constraint, but leave the transaction intact. > > > >Which databases behave that way? Does COMMIT succeed even if some > >statements failed? > > Oracle, for one, behaves that way... Yes, COMMIT does succeed even if some > statement(s) threw errors. > > Probably, the 'other' DBs have implemented that by an implicit savepoint > just before a command, and rollong back to it automatically, if the > transaction fails. > > This is quite a desirable feature... Why bother with transactions at all if autocommit is enabled ?? Karsten -- GPG key ID E4071346 @ wwwkeys.pgp.net E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346
