I'm trying to copy 5 files from S3 to 5 Redshift tables. I'd like to do an 'all or none' type of transaction where if one of the `COPY` commands fails, then nothing is copied over. So I've tried copying data in a `TRANSACTION`, but the transaction is still committing the `COPY` statements that completed before the errors were raised later in the script.

Is it possible to delay the full `COPY` commits until all of them are completed without errors?