Re: autogenerating error code lists (was Re: [COMMITTERS] pgsql: Add foreign data wrapper error code values for SQL/MED.)

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>

To: Jan Urbański <wulczer@wulczer.org>

Cc: Robert Haas <robertmhaas@gmail.com>, pgsql-hackers@postgresql.org, Shigeru HANADA <hanada@metrosystems.co.jp>

Date: 2010-12-26T20:17:15Z

Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

Add foreign data wrapper error code values for SQL/MED.
- 85cff3ce7f36 9.1.0 cited

=?UTF-8?B?SmFuIFVyYmHFhHNraQ==?= <wulczer@wulczer.org> writes:
> Makes sense. Wait, no, errcodes.sgml includes the entries for success
> and warnings, but the plpgsql conditions list does not. So we need a
> separate column to differentiate.

OK.  But not 0/1 please.  Maybe 'E', 'W', or 'S' ?  And again, fixed
width columns first, so something like

	sqlstate  E/W/S  errcode_macro_name  plpgsql_condition_name

where I guess we could still make the plpgsql condition name optional.

			regards, tom lane