I'm currently fixing up ecpg for the new error codes. (ecpg was doing string comparisons to detect certain failure conditions, which no longer works, so this is a must-fix.) Many of the failure conditions that ecpg detects explicitly can be mapped to SQLSTATE codes that are defined in the standard or have been assigned for use by the backend. Some codes, however, will end up being specific to ecpg. I'm wondering what kind of scheme we should use to allow clients to reserve some SQLSTATE codes for their own use.
The errors I'm currently looking at can be thought of as "internal errors", so should I be using the class XX, or maybe XY as internal error on the client side, or maybe YE as internal error on the client side in ecpg (so YL could be libpq, YO the ODBC driver, etc.)? What about creating client-specific subclasses of existing classes? Is the DB2 SQLSTATE reference, where some codes were apparently taken from, available somewhere? (A web search doesn't show anything useful.) -- Peter Eisentraut [EMAIL PROTECTED] ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org