Provide ability for Postgres registry to use SQL transactions
This may not always be desirable, for example if migrations involve side effects outside the Postgres database, but in the common case of DDL migrations to the same database where the registry is stored we should be able to do the migration and the registry log commit in one SQL transaction. This would remove the possibility of ever ending up in a tainted state.