Filipe Pina <filipe.p...@impactzero.pt> writes: > It will try 5 times to execute each instruction (in case of > OperationError) and in the last one it will raise the last error it > received, aborting.
> Now my problem is that aborting for the last try (on a restartable > error - OperationalError code 40001) is not an option... It simply > needs to get through, locking whatever other processes and queries it > needs. I think you need to reconsider your objectives. What if two or more transactions are repeatedly failing and retrying, perhaps because they conflict? They can't all forcibly win. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general