SCM

[#1001091] Invalid behavior when DataAdapter.ContinueUpdateOnError is set

View Trackers | Bugs | Download .csv | Monitor

Date:
2006-12-29 12:20
Priority:
3
State:
Open
Submitted by:
Andrus Moor (kobruleht)
Assigned to:
Nobody (None)
Npgsql Version:
1.0
Category:
Group:
Resolution:
None
Summary:
Invalid behavior when DataAdapter.ContinueUpdateOnError is set

Detailed description
.NET data provider must implement DataAdapter.ContinueUpdateOnError
property in transaction.

ContinueUpdateOnError requires that transaction continues after error. In this case .NET can mark all bad rows in DataGrid. User can see all errors together.

Inside transaction after error PostgreSQL returns message

"Current transaction aborted, command ignored after end of transaction block"

for all subsequent commands.

npgsql does NOT have any support for fix this.
It marks ALL subsequent commands as invalid.

If ContinueUpdateOnError is set to true,
NpgsqlDataAdapter must issue SAVEPOINT command before each command and in case of error must issue ROLLBACK TO SAVEPOINT command

Followup

No Followups Have Been Posted

Attached Files:

Changes:

No Changes Have Been Made to This Item

Powered By FusionForge