DBD::PG question

From: Frank Bax <fbax(at)sympatico(dot)ca>
To: pgsql-interfaces(at)postgresql(dot)org
Subject: DBD::PG question
Date: 2005-03-29 12:30:48
Message-ID: 5.2.1.1.0.20050329072552.0581e2b0@pop6.sympatico.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-interfaces by date

  From Date Subject
Next Message Frank Bax 2005-03-29 17:54:22 Re: DBD::PG question
Previous Message John DeSoi 2005-03-29 01:13:59 Re: MS Access/ODBC 'ERROR: invalid input syntax fo