DBD::PG question - Mailing list pgsql-interfaces

From Frank Bax
Subject DBD::PG question
Date
Msg-id 5.2.1.1.0.20050329072552.0581e2b0@pop6.sympatico.ca
Whole thread Raw
Responses Re: DBD::PG question
Re: DBD::PG question
List pgsql-interfaces
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?

Frank



pgsql-interfaces by date:

Previous
From: John DeSoi
Date:
Subject: Re: MS Access/ODBC 'ERROR: invalid input syntax fo
Next
From: Frank Bax
Date:
Subject: Re: DBD::PG question