http://postgres.cz/index.php?action=history&feed=atom&title=Enhanced_diagnostics_statement Enhanced diagnostics statement - Historie editací 2026-04-29T20:43:49Z Historie editací této stránky MediaWiki 1.43.3 http://postgres.cz/index.php?title=Enhanced_diagnostics_statement&diff=242&oldid=prev 85.160.79.39 v 24. 2. 2007, 14:21 2007-02-24T14:21:02Z <p></p> <p><b>Nová stránka</b></p><div>&lt;pre&gt;<br /> - resignal statement<br /> CREATE OR REPLACE FUNCTION cc()<br /> RETURNS void AS<br /> $$<br /> BEGIN<br /> DECLARE frk CONDITION;<br /> DECLARE brk CONDITION;<br /> DECLARE x, y, z text;<br /> DECLARE CONTINUE HANDLER FOR SQLEXCEPTION<br /> BEGIN<br /> GET STACKED DIAGNOSTICS x = CONDITION_IDENTIFIER, y = RETURNED_SQLSTATE;<br /> GET STACKED DIAGNOSTICS CONDITION 1 z = MESSAGE_TEXT;<br /> PRINT &#039;handler &gt;&#039;, x,&#039;,&#039;, y,&#039;,&#039;, z;<br /> GET DIAGNOSTICS x = CONDITION_IDENTIFIER, y = RETURNED_SQLSTATE, z = MESSAGE_TEXT;<br /> PRINT &#039;handler &gt;&#039;, x,&#039;,&#039;, y,&#039;,&#039;, z;<br /> RESIGNAL SET PG_MESSAGE_DETAIL = &#039;any detail&#039;;<br /> END;<br /> PRINT &#039;start&#039;;<br /> SIGNAL frk;<br /> SIGNAL SQLSTATE &#039;33333&#039; SET MESSAGE_TEXT = &#039;err message&#039;;<br /> PRINT &#039;finish&#039;;<br /> END;<br /> $$ LANGUAGE plpgpsm;<br /> SELECT cc();<br /> &lt;/pre&gt;</div> 85.160.79.39