Re: Practical sets of SQLSTATE values? - Mailing list pgsql-hackers

From Jeff
Subject Re: Practical sets of SQLSTATE values?
Date
Msg-id Pine.BSF.4.44.0305301204470.66728-100000@torgo.978.org
Whole thread Raw
In response to Practical sets of SQLSTATE values?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Fri, 30 May 2003, Tom Lane wrote:

> What do other DBMSes do about this?  Seems like it would make sense to
> borrow as many SQLSTATE codes as we can from Oracle or DB2 or some other
> big player ... especially if there's any commonality in their
> extensions.  Anyone have lists of implementation-defined SQLSTATEs for
> the big commercial DBs?
>

On informix SQLSTATE is mostly for getting the oh.. lets call it the
"genre" of the error.  They use a separate error code which contains the
specific error.

--
Jeff Trout <jeff@jefftrout.com>
http://www.jefftrout.com/
http://www.stuarthamm.net/




pgsql-hackers by date:

Previous
From: Oleg Bartunov
Date:
Subject: XML and postgres
Next
From: Tom Lane
Date:
Subject: Re: index suggestion for 7.4