On Mon, Sep 29, 2003 at 09:32:10AM -0400, Hardy Merrill wrote:
> Thomas A. Lowery [EMAIL PROTECTED] wrote:
> > # Does the error message contains the phrase: duplicate key
> > if ($dbh->errstr =~ m/duplicate\skey/i) {
> ^^^^^^^^^^^^^^
> Just to clarify, as Thomas said above, each database produces
> different error messages to indicate that you are trying
> to insert a duplicate key - so what you search for here will
> vary depending on which database you are using.
Of course, in an ideal world, DBD's would all set $DBI::state
($h->state) to the appropriate value: "23000"
Maybe someone could define a list of the errors that most frequently
need to be explicitly checked for. The DBI spec could then list
those along with the standard SQL_STATE error codes and suggest that
drivers support at least that basic set of codes.
Volunteers?
Tim.
