Re: different transaction handling between postgresql and - Mailing list pgsql-general

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
mascarm@mascari.com