tests for procedures(not function) having transaction block in it(like commit)

[mgs]

is there a way to write tests for procedure having commit block in it using pgtap I am using scripting style to write tests without actually modifying procedure itself.

CREATE OR REPLACE PROCEDURE foo.do_something(IN i_value INT)
AS
$$
BEGIN
     # some delete statement 
      commit;
END; $$
LANGUAGE plpgsql;

[David E. Wheeler]

I don’t think you can in a single test; pgTAP was written long before this feature existed, and generally assumes all tests run in a single transaction. Perhaps you could write other procedures that do the testing and control the transactions?

I’m guessing here, as I’ve not messed with procedures yet myself.

Best,

David