I want to copy
data from a source into a PostgreSQL table and I want the content of the target PG-table to change only if the whole operation is successful.

My approach
is to get the truncate and all inserts done in one single transaction. One way
to do this is setting “Features Per Transaction” to >= number of features in
the source (some hardcoded value, perhaps 9999999999999999999999). But is there
a better way?

In the documentation
I’ve found info on setting “Features Per Transaction” to VARIABLE in
combination with using a fme_db_transaction attribute. I’ve tried this, both setting
fme_db_transaction to COMMIT_AFTER and to IGNORE. But the log file still says
that there are 1000 features per commit (=the default number).