Message-ID: <543EA2CC.6010402@gmail.com>
Date: Wed, 15 Oct 2014 10:37:32 -0600
From: Rob Sargent <robjsargent@gmail.com>
User-Agent: Mozilla/5.0 (X11; Linux x86_64;
 rv:24.0) Gecko/20100101 Thunderbird/24.8.0
MIME-Version: 1.0
To: pgsql-general@postgresql.org
Subject: Re: Any postgres API available to get errorcode for PQerrorMessage
References: <F9567754259D974D88F5F5337C9D219620BD0C43@xmb-aln-x11.cisco.com>
In-Reply-To: <F9567754259D974D88F5F5337C9D219620BD0C43@xmb-aln-x11.cisco.com>
Content-Type: multipart/alternative;
 boundary="------------090004050809080303000104"
Precedence: bulk
Sender: pgsql-general-owner@postgresql.org

This is a multi-part message in MIME format.
--------------090004050809080303000104
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

On 10/15/2014 02:17 AM, Roopeshakumar Narayansa Shalgar (rshalgar) wrote:
>
> HI,
>
> PQerrorMessage pirints the error message like (no space 
> available,etc). Does postgres provide
>
> any  API which gives the error code listed in the below appendix;
>
> http://www.postgresql.org/docs/9.1/static/errcodes-appendix.html
>
> I need the exact error code so that I can shutdown my application 
> whenever I face  the "no space available" problem.
>
> --
>
> Thanks and Regards,
>
> Rupesh
>
Isn't this best done by monitoring tools such as nagios and done much 
before you actually run out of space?

--------------090004050809080303000104
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

<html>
  <head>
    <meta content="text/html; charset=ISO-8859-1"
      http-equiv="Content-Type">
  </head>
  <body bgcolor="#FFFFFF" text="#000000">
    <div class="moz-cite-prefix">On 10/15/2014 02:17 AM, Roopeshakumar
      Narayansa Shalgar (rshalgar) wrote:<br>
    </div>
    <blockquote
cite="mid:F9567754259D974D88F5F5337C9D219620BD0C43@xmb-aln-x11.cisco.com"
      type="cite">
      <meta http-equiv="Content-Type" content="text/html;
        charset=ISO-8859-1">
      <meta name="Generator" content="Microsoft Word 14 (filtered
        medium)">
      <style><!--
/* Font Definitions */
@font-face
	{font-family:Calibri;
	panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0in;
	margin-bottom:.0001pt;
	font-size:11.0pt;
	font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
	{mso-style-priority:99;
	color:blue;
	text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
	{mso-style-priority:99;
	color:purple;
	text-decoration:underline;}
span.EmailStyle17
	{mso-style-type:personal-compose;
	font-family:"Calibri","sans-serif";
	color:windowtext;}
.MsoChpDefault
	{mso-style-type:export-only;
	font-family:"Calibri","sans-serif";}
@page WordSection1
	{size:8.5in 11.0in;
	margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
	{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
      <div class="WordSection1">
        <p class="MsoNormal">HI,<o:p></o:p></p>
        <p class="MsoNormal"><o:p>&nbsp;</o:p></p>
        <p class="MsoNormal">PQerrorMessage pirints the error message
          like (no space available,etc). Does postgres provide
          <o:p></o:p></p>
        <p class="MsoNormal">any &nbsp;API which gives the error code listed
          in the below appendix;<o:p></o:p></p>
        <p class="MsoNormal"><o:p>&nbsp;</o:p></p>
        <p class="MsoNormal"><a moz-do-not-send="true"
            href="http://www.postgresql.org/docs/9.1/static/errcodes-appendix.html">http://www.postgresql.org/docs/9.1/static/errcodes-appendix.html</a><o:p></o:p></p>
        <p class="MsoNormal"><o:p>&nbsp;</o:p></p>
        <p class="MsoNormal"><o:p>&nbsp;</o:p></p>
        <p class="MsoNormal">I need the exact error code so that I can
          shutdown my application whenever I face &nbsp;the &#8220;no space
          available&#8221; problem.<o:p></o:p></p>
        <p class="MsoNormal"><o:p>&nbsp;</o:p></p>
        <p class="MsoNormal">--<o:p></o:p></p>
        <p class="MsoNormal">Thanks and Regards,<o:p></o:p></p>
        <p class="MsoNormal">Rupesh<o:p></o:p></p>
      </div>
    </blockquote>
    <font size="-1"><font face="Courier New, Courier, monospace">Isn't
        this best done by monitoring tools such as nagios and done much
        before you actually run out of space?</font></font><br>
  </body>
</html>

--------------090004050809080303000104--