Hi,
I was wondering whether it's possible to batch multiple PostgreSQL queries into one transaction so that if one of my queries fails, the entire batch of queries will fail?
Unfortunately, at this time Retool does not support transactions, but you can set up a chain of multiple queries to run "On Success" of one-another so that if one fails, the remainder of the chain will not be run. Unfortunately this does not undo the previous queries in the way that rolling back a transaction does.
Would you mind posting this as a feature request so that other users who are interested can chime in on this?
@jbretool123 Did you end up solving this? As in perhaps creating a stored procedure in your Postgres and calling it from Retool? If you or @mark have an example on how to do that it would be greatly appreciated!