Re^2: DBD::Pg - $sth->execute($csv

Well, OK.
Your Pastoral Guidance has borne fruit and blessed my scriptural offerings.
I see smoke rising from the alter as I turn the STHandle on the door to data salvation.
But lo, are there wolves among these sheep?
Have I put my trust in a False Religion?

I receive no admonitions from Pg, yet upon SELECT supplications, it is as if my offerings are remembered no more. I wonder, are my indulgences counted as nothing more than lip service?

I accept, of course, the answer to this question may fall outside of the remit of the Perl Priesthood. Perhaps this is a question for the PG Priesthood?

Can Perl Priests intercede with Pg?
Doth thou knowest how to solicit exegetical corrective advice from Pg?

Must I make an open confession of faith with:
$sth->commit();
?

If I say $sth->errstr(); will Pg enlighten me?

Obligations

Comment on Re^2: DBD::Pg - $sth->execute($csv_var) ERROR Select or Download Code

Replies are listed 'Best First'.
Re^3: DBD::Pg - $sth->execute($csv_var) ERROR by roboticus (Chancellor) on Mar 17, 2020 at 15:33 UTC
perlygapes: I'd definitely try the commit to see if that does the trick, but I'd also check to see if the statement had an error or not. If it does, then you can use the AutoCommit flag on the connect statement to avoid having to do a commit after every operation (though you might prefer the safety of handling commit yourself). Since you could be getting an error from Pg, you'll want to check the error status of any command. An insert will fail if you violate a constraint on the table for example. So I tell DBI (on the connect statement) to check every statement and raise errors (using RaiseError and PrintError). ...roboticus When your only tool is a hammer, all problems look like your thumb.	[reply]
Re^4: DBD::Pg - $sth->execute($csv_var) ERROR by perlygapes (Beadle) on Mar 18, 2020 at 03:54 UTC
Hmmm...that's excellent exegesis. Whence I had thought I besought for errors to be caught then taught, I had: `my $dbh = DBI->connect($DSN, $userid, $sesame, { AutoCommit => 0, RaiseError => 1, PrintError => 0 }) or die "Connection failed!\n" . $DBI::errstr;` [download] Hence I shall beseech for errors to be bleached and for Pg to teach me with: `my $dbh = DBI->connect($DSN, $userid, $sesame, { AutoCommit => 1, RaiseError => 1, PrintError => 1 }) or die "Connection failed!\n" . $DBI::errstr;` [download] May thy code be blessed by the Profit of thy scripts.	[reply] [d/l] [select]