pgsql.constants.html

来自「php的帮助文档,涉及到PHP的案例和基本语法,以及实际应用内容」· HTML 代码 · 共 773 行 · 第 1/2 页

   <dd>

    <span class="simpara">
     Returned by <a href="function.pg-transaction-status.html" class="function">pg_transaction_status()</a>. The connection
     is bad.
    </span>
   </dd>

  </dt>

  <dt>

   <span class="term">
    <b><tt>PGSQL_DIAG_SEVERITY</tt></b> 
    (<a href="language.types.integer.html" class="type integer">integer</a>)
   </span>

   <dd>

    <span class="simpara">
     Passed to <a href="function.pg-result-error-field.html" class="function">pg_result_error_field()</a>.
     The severity; the field contents are <i>ERROR</i>, 
     <i>FATAL</i>, or <i>PANIC</i> (in an error message), or 
     <i>WARNING</i>, <i>NOTICE</i>, <i>DEBUG</i>, 
     <i>INFO</i>, or <i>LOG</i> (in a notice message), or a localized 
     translation of one of these. Always present.
    </span>
   </dd>

  </dt>

  <dt>

   <span class="term">
    <b><tt>PGSQL_DIAG_SQLSTATE</tt></b> 
    (<a href="language.types.integer.html" class="type integer">integer</a>)
   </span>

   <dd>

    <span class="simpara">
     Passed to <a href="function.pg-result-error-field.html" class="function">pg_result_error_field()</a>.
     The SQLSTATE code for the error. The SQLSTATE code identifies the type of error 
     that has occurred; it can be used by front-end applications to perform specific 
     operations (such as error handling) in response to a particular database error. 
     This field is not localizable, and is always present.
    </span>
   </dd>

  </dt>

  <dt>

   <span class="term">
    <b><tt>PGSQL_DIAG_MESSAGE_PRIMARY</tt></b> 
    (<a href="language.types.integer.html" class="type integer">integer</a>)
   </span>

   <dd>

    <span class="simpara">
     Passed to <a href="function.pg-result-error-field.html" class="function">pg_result_error_field()</a>.
     The primary human-readable error message (typically one line). Always present.
    </span>
   </dd>

  </dt>

  <dt>

   <span class="term">
    <b><tt>PGSQL_DIAG_MESSAGE_DETAIL</tt></b> 
    (<a href="language.types.integer.html" class="type integer">integer</a>)
   </span>

   <dd>

    <span class="simpara">
     Passed to <a href="function.pg-result-error-field.html" class="function">pg_result_error_field()</a>.
     Detail: an optional secondary error message carrying more detail about the problem. May run to multiple lines.
    </span>
   </dd>

  </dt>

  <dt>

   <span class="term">
    <b><tt>PGSQL_DIAG_MESSAGE_HINT</tt></b> 
    (<a href="language.types.integer.html" class="type integer">integer</a>)
   </span>

   <dd>

    <span class="simpara">
     Passed to <a href="function.pg-result-error-field.html" class="function">pg_result_error_field()</a>.
     Hint: an optional suggestion what to do about the problem. This is intended to differ from detail in that it
     offers advice (potentially inappropriate) rather than hard facts. May run to multiple lines.
    </span>
   </dd>

  </dt>

  <dt>

   <span class="term">
    <b><tt>PGSQL_DIAG_STATEMENT_POSITION</tt></b> 
    (<a href="language.types.integer.html" class="type integer">integer</a>)
   </span>

   <dd>

    <span class="simpara">
     Passed to <a href="function.pg-result-error-field.html" class="function">pg_result_error_field()</a>.
     A string containing a decimal integer indicating an error cursor position as an index into the original 
     statement string. The first character has index 1, and positions are measured in characters not bytes.
    </span>
   </dd>

  </dt>

  <dt>

   <span class="term">
    <b><tt>PGSQL_DIAG_INTERNAL_POSITION</tt></b> 
    (<a href="language.types.integer.html" class="type integer">integer</a>)
   </span>

   <dd>

    <span class="simpara">
     Passed to <a href="function.pg-result-error-field.html" class="function">pg_result_error_field()</a>.
     This is defined the same as the <b><tt>PG_DIAG_STATEMENT_POSITION</tt></b> field, but 
     it is used when the cursor position refers to an internally generated 
     command rather than the one submitted by the client. The 
     <b><tt>PG_DIAG_INTERNAL_QUERY</tt></b> field will always appear when this 
     field appears.
    </span>
   </dd>

  </dt>

  <dt>

   <span class="term">
    <b><tt>PGSQL_DIAG_INTERNAL_QUERY</tt></b> 
    (<a href="language.types.integer.html" class="type integer">integer</a>)
   </span>

   <dd>

    <span class="simpara">
     Passed to <a href="function.pg-result-error-field.html" class="function">pg_result_error_field()</a>.
     The text of a failed internally-generated command. This could be, for example, a 
     SQL query issued by a PL/pgSQL function.
    </span>
   </dd>

  </dt>

  <dt>

   <span class="term">
    <b><tt>PGSQL_DIAG_CONTEXT</tt></b> 
    (<a href="language.types.integer.html" class="type integer">integer</a>)
   </span>

   <dd>

    <span class="simpara">
     Passed to <a href="function.pg-result-error-field.html" class="function">pg_result_error_field()</a>.
     An indication of the context in which the error occurred. Presently 
     this includes a call stack traceback of active procedural language 
     functions and internally-generated queries. The trace is one entry 
     per line, most recent first.
    </span>
   </dd>

  </dt>

  <dt>

   <span class="term">
    <b><tt>PGSQL_DIAG_SOURCE_FILE</tt></b> 
    (<a href="language.types.integer.html" class="type integer">integer</a>)
   </span>

   <dd>

    <span class="simpara">
     Passed to <a href="function.pg-result-error-field.html" class="function">pg_result_error_field()</a>.
     The file name of the PostgreSQL source-code location where the error 
     was reported.
    </span>
   </dd>

  </dt>

  <dt>

   <span class="term">
    <b><tt>PGSQL_DIAG_SOURCE_LINE</tt></b> 
    (<a href="language.types.integer.html" class="type integer">integer</a>)
   </span>

   <dd>

    <span class="simpara">
     Passed to <a href="function.pg-result-error-field.html" class="function">pg_result_error_field()</a>.
     The line number of the PostgreSQL source-code location where the 
     error was reported.
    </span>
   </dd>

  </dt>

  <dt>

   <span class="term">
    <b><tt>PGSQL_DIAG_SOURCE_FUNCTION</tt></b> 
    (<a href="language.types.integer.html" class="type integer">integer</a>)
   </span>

   <dd>

    <span class="simpara">
     Passed to <a href="function.pg-result-error-field.html" class="function">pg_result_error_field()</a>.
     The name of the PostgreSQL source-code function reporting the error.
    </span>
   </dd>

  </dt>


  <dt>

   <span class="term">
    <b><tt>PGSQL_ERRORS_TERSE</tt></b> 
    (<a href="language.types.integer.html" class="type integer">integer</a>)
   </span>

   <dd>

    <span class="simpara">
     Passed to <a href="function.pg-set-error-verbosity.html" class="function">pg_set_error_verbosity()</a>.
     Specified that returned messages include severity, primary text, 
     and position only; this will normally fit on a single line.
    </span>
   </dd>

  </dt>

  <dt>

   <span class="term">
    <b><tt>PGSQL_ERRORS_DEFAULT</tt></b> 
    (<a href="language.types.integer.html" class="type integer">integer</a>)
   </span>

   <dd>

    <span class="simpara">
     Passed to <a href="function.pg-set-error-verbosity.html" class="function">pg_set_error_verbosity()</a>.
     The default mode produces messages that include the above 
     plus any detail, hint, or context fields (these may span 
     multiple lines).
    </span>
   </dd>

  </dt>

  <dt>

   <span class="term">
    <b><tt>PGSQL_ERRORS_VERBOSE</tt></b> 
    (<a href="language.types.integer.html" class="type integer">integer</a>)
   </span>

   <dd>

    <span class="simpara">
     Passed to <a href="function.pg-set-error-verbosity.html" class="function">pg_set_error_verbosity()</a>.
     The verbose mode includes all available fields.
    </span>
   </dd>

  </dt>


  <dt>

   <span class="term">
    <b><tt>PGSQL_STATUS_LONG</tt></b> 
    (<a href="language.types.integer.html" class="type integer">integer</a>)
   </span>

   <dd>

    <span class="simpara">
     Passed to <a href="function.pg-result-status.html" class="function">pg_result_status()</a>.  Indicates that
     numerical result code is desired.
    </span>
   </dd>

  </dt>

  <dt>

   <span class="term">
    <b><tt>PGSQL_STATUS_STRING</tt></b> 
    (<a href="language.types.integer.html" class="type integer">integer</a>)
   </span>

   <dd>

    <span class="simpara">
     Passed to <a href="function.pg-result-status.html" class="function">pg_result_status()</a>.  Indicates that
     textual result command tag is desired.
    </span>
   </dd>

  </dt>


  <dt>

   <span class="term">
    <b><tt>PGSQL_CONV_IGNORE_DEFAULT</tt></b> 
    (<a href="language.types.integer.html" class="type integer">integer</a>)
   </span>

   <dd>

    <span class="simpara">
     Passed to <a href="function.pg-convert.html" class="function">pg_convert()</a>.
     Ignore default values in the table during conversion.
    </span>
   </dd>

  </dt>

  <dt>

   <span class="term">
    <b><tt>PGSQL_CONV_FORCE_NULL</tt></b> 
    (<a href="language.types.integer.html" class="type integer">integer</a>)
   </span>

   <dd>

    <span class="simpara">
     Passed to <a href="function.pg-convert.html" class="function">pg_convert()</a>.
     Use SQL <i>NULL</i> in place of an empty <a href="language.types.string.html" class="type string">string</a>.
    </span>
   </dd>

  </dt>

  <dt>

   <span class="term">
    <b><tt>PGSQL_CONV_IGNORE_DEFAULT</tt></b> 
    (<a href="language.types.integer.html" class="type integer">integer</a>)
   </span>

   <dd>

    <span class="simpara">
     Passed to <a href="function.pg-convert.html" class="function">pg_convert()</a>.
     Ignore conversion of <b><tt>NULL</tt></b> into SQL <i>NOT NULL</i> columns.
    </span>
   </dd>

  </dt>


 </dl>

</div>
<hr /><div style="text-align: center;">
 <div class="prev" style="text-align: left; float: left;"><a href="pgsql.resources.html">Resource Types</a></div>
 <div class="next" style="text-align: right; float: right;"><a href="pgsql.examples.html">Examples</a></div>
 <div class="up"><a href="book.pgsql.html">PostgreSQL</a></div>
 <div class="home"><a href="index.html">PHP Manual</a></div>
</div></body></html>