Re: psycopg2: proper positioning of .commit() within try: except: blocks

Jon Ribbens <jon+usenet@unequivocal.eu> wrote or quoted:

What if there's an exception in your exception handler? I'd put the
rollback in the 'finally' handler, so it's always called.

  To make this happen, you'd better kick off with the rollback right
  at the beginning of the "finally:" block. Otherwise, some gnarly
  exception might rear its ugly head before the rollback gets called!