Joe Conway <mail(at)joeconway(dot)com> writes:
> Tom Lane wrote:
>> Anyone have lists of implementation-defined SQLSTATEs for
>> the big commercial DBs?
> Does this help?
Some, but the mapping table is mostly pretty vague --- for instance,
it's quite unclear whether they provide subclasses in the 42xxx series
errors, or if they all come out as 42000. If there are subclasses,
which subclass codes correspond to which ORA-foo codes? A more complete
mapping table would help.
The same site has a copy of the complete Oracle 9i error message book:
but I couldn't find any mention at all of SQLSTATE codes in it. It's
pretty clear that Oracle regards SQLSTATE as an ugly stepchild. (Which
might be a fair assessment ;-), but it's at least somewhat standard ...)
We might do better following DB2's lead.
regards, tom lane
In response to
pgsql-hackers by date
|Next:||From: Bruno Wolff III||Date: 2003-05-30 16:02:00|
|Subject: index suggestion for 7.4|
|Previous:||From: Nailah Ogeer||Date: 2003-05-30 15:07:41|