database = postagresql
I want to execute a start transaction before returning true in row_inserting then in row_inserted I want to run a bunch of queries, then i run commit transaction when am sure everything has saved.
The effect i want is everything query i run in between including the one ran by row_inserting to have completed successfully before i run the commit.
I have tried putting Execute("START TRANSACTION"); before returning true in row_inserting but it still commits even without me putting Execute("COMMIT TRANSACTION"); in row_inserted
I know the trandactions work coz I can put START TRANSACTION in pg admin and run some queries and they wont be saved.
I also Use the same approach alot in phpmaker with ew_Execuete("START TRANSACTION") before return true of row_inserting and it works.
So how do i DO it here, not on row_inserting only coz i will have some other queries in custom action which i need to enclose in a transaction as well.