Easy. Just use dblink or foreign table to execute part of the statement inside other transaction. dblink to the same server/db is often used as way to create an "AUTONOMOUS_TRANSACTION"

Thanks for the chuckle.

(Yes, I know this adds nothing to the discussion)