Hi, thanks for the clarification Vinay K..
One follow-up question:
If I perform an Insert, Update, or Upsert operation using the PostgreSQL connector in Workato, and the operation is successfully committed, is there any way to rollback those changes later from Workato itself?
For example, in webMethods, when using Local Transaction, multiple database operations can be rolled back if a failure occurs before the transaction is committed.
In Workato, if I use standard PostgreSQL connector actions (Insert/Update/Upsert), are those operations automatically committed? If yes, is the only recovery option to:
Handle transactions at the database level using BEGIN, COMMIT, and ROLLBACK
Use stored procedures
Implement compensating actions (for example, a DELETE after a failed INSERT)
Has anyone implemented similar rollback requirements with the PostgreSQL connector and, if so, what approach worked best?
