Thread: plpsm - plpgpsm: Condition without spec.

plpsm - plpgpsm: Condition without spec.

From

okbob@pgfoundry.org (User Okbob)

Date:

05 January 2007, 13:42:55

Log Message:
-----------
Condition without spec. SQLSTATE use reserved SQLSTATE P1001. With its
sqlstate condition name have to be equal to message (you cannot catch this
condition via SQLSTATE, only via condition name).

For selecting the most specific condition handler is used 3 pass algorithm.
Precedence is SQLSTATE (level 3,2,1), SQLSTATE Class (level 2,1), general
handler (level 1). I finding any possible handler on any level. If I found
only one handler, I use its, else i increase level and I repeat searching.
If isn't possible increase level trow exception 



VS: ----------------------------------------------------------------------

Modified Files:
--------------
    plpgpsm/src:
        gram.y (r1.24 -> r1.25)
        (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/plpsm/plpgpsm/src/gram.y.diff?r1=1.24&r2=1.25)
        pl_exec.c (r1.20 -> r1.21)
        (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/plpsm/plpgpsm/src/pl_exec.c.diff?r1=1.20&r2=1.21)
        plerrcodes.h (r1.1.1.1 -> r1.2)
        (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/plpsm/plpgpsm/src/plerrcodes.h.diff?r1=1.1.1.1&r2=1.2)
        plpgpsm.h (r1.18 -> r1.19)
        (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/plpsm/plpgpsm/src/plpgpsm.h.diff?r1=1.18&r2=1.19)