Jörg Schulz wrote: >>... I have this feeling the reason Oracle gives this result may >>be again because transactions have been switched off! > > This snippet comes from the Oracle console: > (table name is "a" not "test" / messages are in german) > ...
> SQL> select * from a; > > A > ---------- > 1 > 3 > 4 > 2 Presumably Oracle is not rolling back a duplicate key violation, allowing the transaction to continue. This is an often requested feature not present in PostgreSQL. Mike Mascari [EMAIL PROTECTED] ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
