Postgres AWS RDS Transaction failure?

**Describe the bug**
When attempting to run the following command against an AWS RDS Postgres instance it reports success but doesn't actually perform the scripts, with the exception of the permissions folder.
```sh
grate --silent --transaction --databasetype postgres -r xxx --commandtimeout 7200 --env dev --connectionstring "$(connectionString)" --files ${{ parameters.scriptsDir }} -v Trace
```

**To Reproduce**
Create a repo that deploys to an AWS RDS Postgres instance using transactions

**Expected behavior**
All scripts ran successfully

**Desktop (please complete the following information):**
- OS: Linux

**Additional context**
In looking at the trace output I noticed that all scripts not in `permissions` would output:
`[SQL] Running (on connection 'Default', transaction handling 'Default'):`

However, the `permissions` folder would output:
`[SQL] Running (on connection 'Default', transaction handling 'Autonomous'):`