close (and auto-drop) temporary tables before
rolling back the last transaction in the connection.