DBD::Pg Transcations handleing

The default is to have AutoCommit set to 1.

To use transactions, you must have AutoCommit OFF:

      $dbh->{'AutoCommit'} = 0;

To save changes and commit:

      $dbh->commit();

To revert to where autocommit was taken off

       $dbh->rollback();

 Then after your finished remember to set AutoCommit:

    $dbh->{'AutoCommit'} = 1;