Subject Re: [firebird-support] Re: INSERT or Update and conflict
Author Milan Babuskov
svanderclock wrote:
> yes, i was thinking to do like you say, handle the error in the
> client interface... but is not a problem for firebird to receive too
> lot of error like this (duplicate reccord or lock conflict?)

Primary key violation error is quite normal event and there is no harm done.

> in case of error, is it better for the stability of firebird to
> commit the transaction or rollback it (nothing was inserted or
> updated cause of the error)

I believe it is better to commit, but someone might correct me on that one.

Milan Babuskov