Обсуждение: plpsm - plpgpsm: Condition without spec.

Поиск
Список
Период
Сортировка

plpsm - plpgpsm: Condition without spec.

От
okbob@pgfoundry.org (User Okbob)
Дата:
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)