Re: Why ContinueUpdateOnError is not implemented in npgsql

["Andrus" <kobruleht2(at)hot(dot)ee>]

>> There are only two ways fix this issue.
>> NpgsqlDataAdapter must invoke automatic ROLLBACK after each error
>> or use checkpoints before each command.
>
> Yup, a savepoint before each command is required if that's the behavior
> you want.  Yes, that adds overhead.  The reason it's not automatic is
> exactly that it adds overhead, which many applications don't need or
> want.  But if you have to have it, that's what you do.

If I want to add 10000 records, using savepoint before each INSERT command 
makes program very slow.

Why MS SQL server and Oracle does not have this issue and implement 
ContinueUpdateOnError fast ?

Is this issue caused by PostgreSQL design failure ?

Andrus.