On Tue, Sep 30, 2003 at 08:57:35AM -0400, Hardy Merrill wrote: > > So I'm still not clear - for this "failed trying to insert > duplicate key" situation, is 23000 (Integrity Constraint > Violation) going to be the choice?
Yes. (Except for systems that support deferred constraints in which case the commit() could set state to 40002.) > My thought was that we'd > somehow want to know specifically that the violation is caused > by an attempt to insert a duplicate key, but 23000 is a > "generic" constraint violation error. Is a generic constraint > violation error what we want for this? It's all the standard gives you. If you need more details there's always $h->errstr ... Tim.
