X-Git-Url: https://ruin.nu/git/intel?a=blobdiff_plain;f=DB.pm;h=53db830c0f30b2f38012dee396b48e40f54b4880;hb=b2d8b311939cec8d428cdeee57bdb7c83d837d92;hp=76cb9dd7773390112df42fabc26f7b52573afc49;hpb=8fe7db805251b8b4bc2f1558e8a7216c63892a33;p=ND.git diff --git a/DB.pm b/DB.pm index 76cb9dd..53db830 100644 --- a/DB.pm +++ b/DB.pm @@ -11,10 +11,14 @@ our @EXPORT = qw/DB/; sub DB { #Use domain sockets by default - my $dbh = DBI->connect_cached("dbi:Pg:dbname=ndawn", "ndawn", "", {AutoCommit => 1}); + my $dbh = DBI->connect_cached("dbi:Pg:dbname=ndawn", "ndawn", "", {AutoCommit => 1, RaiseError => 1}); #Easy to also use /etc/postgresql/pg_services.conf #my $dbh = DBI->connect_cached("dbi:Pg:service=ndawn","", "", {AutoCommit => 1}); - $dbh->rollback if $dbh->{Executed} || !$dbh->{AutoCommit}; + { + no warnings; + local $dbh->{Warn} = 0; + $dbh->do('ABORT; RESET ALL; SET SESSION AUTHORIZATION DEFAULT; DEALLOCATE ALL'); + } return $dbh; }; 1;