title: localizing a transaction within a procedure externally
body: <p><a href="https://stackoverflow.com/questions/73725723/schema-prefixes-in-postgres-scope-of-called-elements/73726103#73726103">With regard to my previous post</a> , I am trying to avoid schema prefixes by setting <code>search_paths</code>, however, I want to limit the scope as much as possible so I'm doing this:</p>
  <pre><code>BEGIN TRANSACTION;
    SET LOCAL search_path to mySchema;
    CALL STORED_PROCEDURE();
    UPDATE TABLE MYTABLE1(//SOME CODE);
  COMMIT;
  
  CALL STORED_PROCEDURE();
  </code></pre>
  <p>Now, the proc has it's own begin, commit statements, so I'm wondering if the procedure will respect it's outer transaction, i.e.</p>
  <ol>
  <li>Will the <code>stored_procedure</code> respect the search_path set by it's parent transaction block?</li>
  <li>if updating the table fails, will operations done inside the procedure also rollback?</li>
  </ol>