pg.ddx.io pgsql-docs@postgresql.org mailing list archive
help / color / mirror / Atom feedError message listing?
8+ messages / 6 participants
[nested] [flat]
* Error message listing?
@ 2003-08-07 23:04 Josh Berkus <josh@agliodbs.com>
2003-08-07 23:21 ` Re: Error message listing? Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 8+ messages in thread
From: Josh Berkus @ 2003-08-07 23:04 UTC (permalink / raw)
To: pgsql-docs
Folks,
Am I missing something here? We're preparing for migration, but I can't find
anywhere a centralized list of the new error messages. Is it in the source
somewhere? If so, can we add it to the documentation?
--
-Josh Berkus
Aglio Database Solutions
San Francisco
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Error message listing?
2003-08-07 23:04 Error message listing? Josh Berkus <josh@agliodbs.com>
@ 2003-08-07 23:21 ` Tom Lane <tgl@sss.pgh.pa.us>
2003-08-07 23:33 ` Re: Error message listing? Josh Berkus <josh@agliodbs.com>
2003-08-08 07:29 ` Re: Error message listing? Peter Eisentraut <peter_e@gmx.net>
0 siblings, 2 replies; 8+ messages in thread
From: Tom Lane @ 2003-08-07 23:21 UTC (permalink / raw)
To: josh@agliodbs.com; +Cc: pgsql-docs
Josh Berkus <josh@agliodbs.com> writes:
> Am I missing something here? We're preparing for migration, but I
> can't find anywhere a centralized list of the new error messages. Is
> it in the source somewhere? If so, can we add it to the
> documentation?
You could make one by running gettext --- see
http://developer.postgresql.org/docs/postgres/nls.html#AEN55720
I do not especially see the point of adding such a list to the
documentation, however.
Or were you looking for src/include/utils/errcodes.h ?
regards, tom lane
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Error message listing?
2003-08-07 23:04 Error message listing? Josh Berkus <josh@agliodbs.com>
2003-08-07 23:21 ` Re: Error message listing? Tom Lane <tgl@sss.pgh.pa.us>
@ 2003-08-07 23:33 ` Josh Berkus <josh@agliodbs.com>
2003-08-08 11:43 ` Re: Error message listing? Francois Suter <francois@monpetitcoin.com>
2003-08-08 11:59 ` Re: Error message listing? Francois Suter <dba@paragraf.ch>
1 sibling, 2 replies; 8+ messages in thread
From: Josh Berkus @ 2003-08-07 23:33 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-docs
Tom,
> Or were you looking for src/include/utils/errcodes.h ?
More or less.
The issue is that many projects have internal code to handle PG error messages
by parsing them for certain text. The overhaul of message handling is going
to break that code; users need to know what the new messages and/or codes are
before migrating.
--
-Josh Berkus
______AGLIO DATABASE SOLUTIONS___________________________
Josh Berkus
Complete information technology josh@agliodbs.com
and data management solutions (415) 565-7293
for law firms, small businesses fax 621-2533
and non-profit organizations. San Francisco
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Error message listing?
2003-08-07 23:04 Error message listing? Josh Berkus <josh@agliodbs.com>
2003-08-07 23:21 ` Re: Error message listing? Tom Lane <tgl@sss.pgh.pa.us>
2003-08-07 23:33 ` Re: Error message listing? Josh Berkus <josh@agliodbs.com>
@ 2003-08-08 11:43 ` Francois Suter <francois@monpetitcoin.com>
1 sibling, 0 replies; 8+ messages in thread
From: Francois Suter @ 2003-08-08 11:43 UTC (permalink / raw)
To: josh@agliodbs.com; +Cc: pgsql-docs
> The issue is that many projects have internal code to handle PG error
> messages
> by parsing them for certain text. The overhaul of message handling
> is going
> to break that code; users need to know what the new messages and/or
> codes are
> before migrating.
I concur, I have such an application and it would be really useful to
have the new error messages and codes.
Cheers
---------------
Francois
Home page: http://www.monpetitcoin.com/
"Would Descartes have programmed in Pascal?" - Umberto Eco
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Error message listing?
2003-08-07 23:04 Error message listing? Josh Berkus <josh@agliodbs.com>
2003-08-07 23:21 ` Re: Error message listing? Tom Lane <tgl@sss.pgh.pa.us>
2003-08-07 23:33 ` Re: Error message listing? Josh Berkus <josh@agliodbs.com>
@ 2003-08-08 11:59 ` Francois Suter <dba@paragraf.ch>
1 sibling, 0 replies; 8+ messages in thread
From: Francois Suter @ 2003-08-08 11:59 UTC (permalink / raw)
To: josh@agliodbs.com; +Cc: pgsql-docs
> The issue is that many projects have internal code to handle PG error
> messages
> by parsing them for certain text. The overhaul of message handling
> is going
> to break that code; users need to know what the new messages and/or
> codes are
> before migrating.
I concur, I have such an application and it would be really useful to
have the new error messages and codes.
Cheers
---------------
Francois
Home page: http://www.monpetitcoin.com/
"Would Descartes have programmed in Pascal?" - Umberto Eco
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Error message listing?
2003-08-07 23:04 Error message listing? Josh Berkus <josh@agliodbs.com>
2003-08-07 23:21 ` Re: Error message listing? Tom Lane <tgl@sss.pgh.pa.us>
@ 2003-08-08 07:29 ` Peter Eisentraut <peter_e@gmx.net>
2003-08-08 13:21 ` Re: Error message listing? Tom Lane <tgl@sss.pgh.pa.us>
1 sibling, 1 reply; 8+ messages in thread
From: Peter Eisentraut @ 2003-08-08 07:29 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: josh@agliodbs.com; pgsql-docs
Tom Lane writes:
> Or were you looking for src/include/utils/errcodes.h ?
I think we should put such a list in the documentation, at least for those
error codes that we have really assigned.
--
Peter Eisentraut peter_e@gmx.net
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Error message listing?
2003-08-07 23:04 Error message listing? Josh Berkus <josh@agliodbs.com>
2003-08-07 23:21 ` Re: Error message listing? Tom Lane <tgl@sss.pgh.pa.us>
2003-08-08 07:29 ` Re: Error message listing? Peter Eisentraut <peter_e@gmx.net>
@ 2003-08-08 13:21 ` Tom Lane <tgl@sss.pgh.pa.us>
2003-08-08 19:42 ` Re: Error message listing? elein <elein@varlena.com>
0 siblings, 1 reply; 8+ messages in thread
From: Tom Lane @ 2003-08-08 13:21 UTC (permalink / raw)
To: Peter Eisentraut <peter_e@gmx.net>; +Cc: josh@agliodbs.com; pgsql-docs
Peter Eisentraut <peter_e@gmx.net> writes:
> Tom Lane writes:
>> Or were you looking for src/include/utils/errcodes.h ?
> I think we should put such a list in the documentation, at least for those
> error codes that we have really assigned.
I have no objection to that. I have doubts about the utility of a
listing of message texts, but the SQLSTATE codes seem reasonable to
document.
Would it be possible to generate the list automatically from errcodes.h,
to simplify future maintenance?
regards, tom lane
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Error message listing?
2003-08-07 23:04 Error message listing? Josh Berkus <josh@agliodbs.com>
2003-08-07 23:21 ` Re: Error message listing? Tom Lane <tgl@sss.pgh.pa.us>
2003-08-08 07:29 ` Re: Error message listing? Peter Eisentraut <peter_e@gmx.net>
2003-08-08 13:21 ` Re: Error message listing? Tom Lane <tgl@sss.pgh.pa.us>
@ 2003-08-08 19:42 ` elein <elein@varlena.com>
0 siblings, 0 replies; 8+ messages in thread
From: elein @ 2003-08-08 19:42 UTC (permalink / raw)
To: pgsql-docs@postgresql.org, Tom Lane <tgl@sss.pgh.pa.us>; +Cc: elein <elein@varlena.com>
The point of including the message texts is
for people supporting various versions who
are looking directly at the message texts
for earlier versions.
This also allows them to upgrade the error
handling to use the new error codes instead
of relying on the message text (which is what
we want).
elein
On Fri, Aug 08, 2003 at 09:21:51AM -0400, Tom Lane wrote:
> Peter Eisentraut <peter_e@gmx.net> writes:
> > Tom Lane writes:
> >> Or were you looking for src/include/utils/errcodes.h ?
>
> > I think we should put such a list in the documentation, at least for those
> > error codes that we have really assigned.
>
> I have no objection to that. I have doubts about the utility of a
> listing of message texts, but the SQLSTATE codes seem reasonable to
> document.
>
> Would it be possible to generate the list automatically from errcodes.h,
> to simplify future maintenance?
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings
>
^ permalink raw reply [nested|flat] 8+ messages in thread
end of thread, other threads:[~2003-08-08 19:42 UTC | newest]
Thread overview: 8+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-08-07 23:04 Error message listing? Josh Berkus <josh@agliodbs.com>
2003-08-07 23:21 ` Tom Lane <tgl@sss.pgh.pa.us>
2003-08-07 23:33 ` Josh Berkus <josh@agliodbs.com>
2003-08-08 11:43 ` Francois Suter <francois@monpetitcoin.com>
2003-08-08 11:59 ` Francois Suter <dba@paragraf.ch>
2003-08-08 07:29 ` Peter Eisentraut <peter_e@gmx.net>
2003-08-08 13:21 ` Tom Lane <tgl@sss.pgh.pa.us>
2003-08-08 19:42 ` elein <elein@varlena.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox