Thread: catching errors from BDI.pm

Hi,

I am having trouble catching errors from postgress. I am connecting to the
database via perl and DBI.pm The following will work

($dbh = DBI->connect("$dsn", "", "") ) or (print $DBI::errstr and exit());

But this wont (from deliberately spelled wrong)
($sth=$dbh->prepare("select * form tablename")) || (
    # error
    print "\nError".$dbh->errstr
    # error
    );


Actually it will work from a telnet prompt, but if I run this script in a
cgi, it writes the error to the error log instead of the standard out. It
does not execute the code inside the error comments.

Thank you for your help
Jeff Seese

IIRC, certain kinds of pg errors trigger exceptions that can only be caught
with an eval wrapper.  Not sure, but the DBD::Pg module may just be
parroting the bail-out behavior of the backend.

Regards,
Ed Loehr

Jeffrey wrote:
>
> Hi,
>
> I am having trouble catching errors from postgress. I am connecting to the
> database via perl and DBI.pm The following will work
>
> ($dbh = DBI->connect("$dsn", "", "") ) or (print $DBI::errstr and exit());
>
> But this wont (from deliberately spelled wrong)
> ($sth=$dbh->prepare("select * form tablename")) || (
>     # error
>     print "\nError".$dbh->errstr
>     # error
>     );
>
> Actually it will work from a telnet prompt, but if I run this script in a
> cgi, it writes the error to the error log instead of the standard out. It
> does not execute the code inside the error comments.
>
> Thank you for your help
> Jeff Seese