Re: Do we need "Diagnostics" sections of SQL command reference pages? - Mailing list pgsql-docs

From Tom Lane
Subject Re: Do we need "Diagnostics" sections of SQL command reference pages?
Date
Msg-id 14583.1062624669@sss.pgh.pa.us
Whole thread Raw
In response to Re: Do we need "Diagnostics" sections of SQL command reference pages?  (Josh Berkus <josh@agliodbs.com>)
List pgsql-docs
Josh Berkus <josh@agliodbs.com> writes:
> I agree that we don't need descriptions of the meaning of each error message
> in the command documentation.

> However, the listing of potential error messages is *very* useful to
> application coders for doing automated handling of errors.   Since we are now
> supporting SQLSTATE responses, perhaps we could have error code ranges for
> the commands?     Or is that totally unreasonable?

It seems completely impractical to guarantee that any particular command
can produce only some-small-subset of all the possible errors.  There
are too many layers of code involved in handling any SQL command.

            regards, tom lane

pgsql-docs by date:

Previous
From: Josh Berkus
Date:
Subject: Re: Do we need "Diagnostics" sections of SQL command reference pages?
Next
From: Bruce Momjian
Date:
Subject: Re: German FAQ update