We are a PerlDBI shop and and are doing a code migration from implicit transaction mode (ie, AutoCommit=>0) to an explicit mode (ie, AutoCommit=>1) .
While the code migration is ongoing (or even permanently) We wish that postgresql reject any UPDATE , DELETE , INSERT , nextval , setval etc unless the session is in a transaction mode . ie they should be preceded by an explicit "BEGIN work;". This shall immensely help us to prevent many bugs in the migration.
Is there any way to accomplish that ? Any help shall be greatly appreciated.