RE: Statement-level rollback

From: Andres Freund [mailto:andres@anarazel.de]
> Isn't the realistic scenario for migrations that people will turn this
> feature on on a more global basis? If they need to do per transaction choices,
> that makes this much less useful for easy migrations.

Agreed.  My approach of per transaction choice may be overkill.  Actually, I didn't think per-transaction change was
reallynecessary in practice.  But I didn't think of any reason to prohibit per transaction change, so I just wanted to
allowflexibility.
 

I think per database/user change (ALTER DATABASE/USER) can be useful, in cases where applications are migrated from
otherDBMSs to a PostgreSQL instance.  That is, database consolidation for easier data analytics and database
management. One database/schema holds data for a PostgreSQL application, and another one stores data for a migrated
application.

Or, should we recommend a separate PostgreSQL instance on a different VM or container, and just introduce the parameter
onlyin postgresql.conf?
 


Regards
Takayuki Tsunakawa