Message-Id: <5.2.1.1.0.20050329124852.00ac9130@pop6.sympatico.ca>
Date: Tue, 29 Mar 2005 12:54:22 -0500
To: pgsql-interfaces@postgresql.org
From: Frank Bax <fbax@sympatico.ca>
Subject: Re: DBD::PG question
In-Reply-To: <5.2.1.1.0.20050329072552.0581e2b0@pop6.sympatico.ca>
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"; format=flowed

At 07:30 AM 3/29/05, Frank Bax wrote:

>In a perl script using DBI and DBD:Pg, I need to drop/create a table:
>   $dbp->{RaiseError} = 0;
>   $dbp->do( "DROP TABLE $table" );
>   $dbp->{RaiseError} = 1;
>   $dbp->do( "CREATE TABLE $table ..." );
>
>If the table does not exist, the "DROP TABLE" produces an error message; 
>but script doesn't die because RaiseError was set to zero.  Is there a way 
>to suppress this error message and then reset the change so an error in 
>create *is* seen?


Thanks to Sean for suggesting I turn PrintError off/on:
         http://search.cpan.org/~timb/DBI-1.48/DBI.pm#PrintError
Works as advertised - if only I'd found those docs before asking my question...