Re: Silencing NOTICEs in Perl Pg - Mailing list pgsql-admin

From Andrew Perrin
Subject Re: Silencing NOTICEs in Perl Pg
Date
Msg-id Pine.LNX.4.21.0208291411050.27669-100000@perrin.socsci.unc.edu
Whole thread Raw
In response to Silencing NOTICEs in Perl Pg  ("David F. Skoll" <dfs@roaringpenguin.com>)
Responses Re: Silencing NOTICEs in Perl Pg  ("David F. Skoll" <dfs@roaringpenguin.com>)
List pgsql-admin
Sure - when you create the database handle, do:

$dbh =
DBI->connect('dbi:Pg:dbname=<dbname>',"<user>","<password>",{RaiseError=>0});

(use the RaiseError feature)

ap

----------------------------------------------------------------------
Andrew J Perrin - http://www.unc.edu/~aperrin
Assistant Professor of Sociology, U of North Carolina, Chapel Hill
clists@perrin.socsci.unc.edu * andrew_perrin (at) unc.edu


On Thu, 29 Aug 2002, David F. Skoll wrote:

> Hi,
>
> Libpq has a way to set the notice processor:
> http://www.postgresql.org/idocs/index.php?libpq-control.html
>
> Is there any way from within the Perl Pg module to turn off the printing
> of NOTICEs to stderr?  It's a bit annoying in one of my projects.
>
> Regards,
>
> David.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>


pgsql-admin by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: timeout
Next
From: Bruce Momjian
Date:
Subject: Re: Passwords and batch processes (was Re: Problem with Dump)