Skip site navigation (1) Skip section navigation (2)

plpsm - plpgpsm: Condition without spec.

From: okbob(at)pgfoundry(dot)org (User Okbob)
To: pgsql-committers(at)postgresql(dot)org
Subject: plpsm - plpgpsm: Condition without spec.
Date: 2007-01-05 14:42:49
Message-ID: 20070105144249.C44BC216F02@pgfoundry.org (view raw or flat)
Thread:
Lists: pgsql-committers
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)

pgsql-committers by date

Next:From: Andrew DunstanDate: 2007-01-05 16:17:55
Subject: pgsql: Call setrlimit if possible in pg_regress to allow core file
Previous:From: Bruce MomjianDate: 2007-01-05 03:19:27
Subject: pgsql: Update float dpow() comment about whick platforms had issues with

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group