>> 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.