Disable long transaction support. This function removes the long transaction support metadata tables, and drops all triggers attached to lock-checked tables.