]> granicus.if.org Git - postgresql/commit
Improve PL/Tcl errorCode facility by providing decoded name for SQLSTATE.
authorTom Lane <tgl@sss.pgh.pa.us>
Fri, 25 Mar 2016 20:54:52 +0000 (16:54 -0400)
committerTom Lane <tgl@sss.pgh.pa.us>
Fri, 25 Mar 2016 20:54:52 +0000 (16:54 -0400)
commitcd37bb78599dcf24cd22a124ce9174b5e2a76880
treef04472f34be85e8a2c7f458c708d8eaaacfcb8dd
parentfb8d2a7f57d87102f0a95025fbf1cad9c341739b
Improve PL/Tcl errorCode facility by providing decoded name for SQLSTATE.

We don't really want to encourage people to write numeric SQLSTATEs in
programs; that's unreadable and error-prone.  Copy plpgsql's infrastructure
for converting between SQLSTATEs and exception names shown in Appendix A,
and modify examples in tests and documentation to do it that way.
doc/src/sgml/pltcl.sgml
src/backend/utils/errcodes.txt
src/pl/tcl/.gitignore
src/pl/tcl/Makefile
src/pl/tcl/expected/pltcl_setup.out
src/pl/tcl/generate-pltclerrcodes.pl [new file with mode: 0644]
src/pl/tcl/pltcl.c
src/pl/tcl/sql/pltcl_setup.sql
src/tools/msvc/Solution.pm