Re: Handling transaction failure due to concurrency errors

Christopher BROWN <brown@reflexe.fr> writes:
> Thanks for the quick reply.  OK for the explanation, and I don't mind
> implementing the retry logic for this case... I just don't know how to
> detect when my code encounters this case (as opposed to other cases that
> can arise, such as unresolved foreign keys when importing data; I don't
> want to get into an infinite retry loop because it will never work in these
> other cases).

Yes, you should only retry in this way for the specific case of a
serialization failure (SQLSTATE 40001).

            regards, tom lane