Skip site navigation (1) Skip section navigation (2)

Re: Practical sets of SQLSTATE values?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Joe Conway <mail(at)joeconway(dot)com>
Cc: pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: Practical sets of SQLSTATE values?
Date: 2003-05-30 15:34:10
Message-ID: 9855.1054308850@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
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?
> http://www.csis.gvsu.edu/GeneralInfo/Oracle/appdev.920/a97269/pc_09err.htm#3174

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:
http://www.csis.gvsu.edu/GeneralInfo/Oracle/server.920/a96525/toc.htm
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

Responses

pgsql-hackers by date

Next:From: Bruno Wolff IIIDate: 2003-05-30 16:02:00
Subject: index suggestion for 7.4
Previous:From: Nailah OgeerDate: 2003-05-30 15:07:41
Subject: Elog

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group