<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <HTML ><HEAD ><TITLE >pg_last_notice</TITLE ><META NAME="GENERATOR" CONTENT="Modular DocBook HTML Stylesheet Version 1.7"><LINK REL="HOME" TITLE="Manual PHP" HREF="index.html"><LINK REL="UP" TITLE="PostgreSQL Functions" HREF="ref.pgsql.html"><LINK REL="PREVIOUS" TITLE="pg_last_error" HREF="function.pg-last-error.html"><LINK REL="NEXT" TITLE="pg_last_oid" HREF="function.pg-last-oid.html"><META HTTP-EQUIV="Content-type" CONTENT="text/html; charset=ISO-8859-2"></HEAD ><BODY CLASS="refentry" BGCOLOR="#FFFFFF" TEXT="#000000" LINK="#0000FF" VLINK="#840084" ALINK="#0000FF" ><DIV CLASS="NAVHEADER" ><TABLE SUMMARY="Header navigation table" WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="0" ><TR ><TH COLSPAN="3" ALIGN="center" >Manual PHP</TH ></TR ><TR ><TD WIDTH="10%" ALIGN="left" VALIGN="bottom" ><A HREF="function.pg-last-error.html" ACCESSKEY="P" >Înapoi</A ></TD ><TD WIDTH="80%" ALIGN="center" VALIGN="bottom" ></TD ><TD WIDTH="10%" ALIGN="right" VALIGN="bottom" ><A HREF="function.pg-last-oid.html" ACCESSKEY="N" >Înainte</A ></TD ></TR ></TABLE ><HR ALIGN="LEFT" WIDTH="100%"></DIV ><H1 ><A NAME="function.pg-last-notice" ></A >pg_last_notice</H1 ><DIV CLASS="refnamediv" ><A NAME="AEN95113" ></A ><P > (PHP 4 >= 4.0.6, PHP 5)</P >pg_last_notice -- Returns the last notice message from PostgreSQL server </DIV ><DIV CLASS="refsect1" ><A NAME="AEN95116" ></A ><H2 >Description</H2 >string <B CLASS="methodname" >pg_last_notice</B > ( resource connection)<BR ></BR ><P > <B CLASS="function" >pg_last_notice()</B > returns the last notice message from the PostgreSQL server specified by <VAR CLASS="parameter" >connection</VAR >. The PostgreSQL server sends notice messages in several cases, e.g. if the transactions can't be continued. With <B CLASS="function" >pg_last_notice()</B >, you can avoid issuing useless queries, by checking whether the notice is related to the transaction or not. </P ><DIV CLASS="warning" ><P ></P ><TABLE CLASS="warning" BORDER="1" WIDTH="100%" ><TR ><TD ALIGN="CENTER" ><B >Avertisment</B ></TD ></TR ><TR ><TD ALIGN="LEFT" ><P > This function is EXPERIMENTAL and it is not fully implemented yet. <B CLASS="function" >pg_last_notice()</B > was added in PHP 4.0.6. However, PHP 4.0.6 has problem with notice message handling. Use of the PostgreSQL module with PHP 4.0.6 is not recommended even if you are not using <B CLASS="function" >pg_last_notice()</B >. </P ><P > This function is fully implemented in PHP 4.3.0. PHP earlier than PHP 4.3.0 ignores database connection parameter. </P ></TD ></TR ></TABLE ></DIV ><P > Notice message tracking can be set to optional by setting 1 for <VAR CLASS="literal" >pgsql.ignore_notice</VAR > in <TT CLASS="filename" >php.ini</TT > from PHP 4.3.0. </P ><P > Notice message logging can be set to optional by setting 0 for <VAR CLASS="literal" >pgsql.log_notice</VAR > in <TT CLASS="filename" >php.ini</TT > from PHP 4.3.0. Unless <VAR CLASS="literal" >pgsql.ignore_notice</VAR > is set to 0, notice message cannot be logged. </P ><P > See also <A HREF="function.pg-query.html" ><B CLASS="function" >pg_query()</B ></A > and <A HREF="function.pg-last-error.html" ><B CLASS="function" >pg_last_error()</B ></A >. </P ></DIV ><DIV CLASS="NAVFOOTER" ><HR ALIGN="LEFT" WIDTH="100%"><TABLE SUMMARY="Footer navigation table" WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="0" ><TR ><TD WIDTH="33%" ALIGN="left" VALIGN="top" ><A HREF="function.pg-last-error.html" ACCESSKEY="P" >Înapoi</A ></TD ><TD WIDTH="34%" ALIGN="center" VALIGN="top" ><A HREF="index.html" ACCESSKEY="H" >Acasã</A ></TD ><TD WIDTH="33%" ALIGN="right" VALIGN="top" ><A HREF="function.pg-last-oid.html" ACCESSKEY="N" >Înainte</A ></TD ></TR ><TR ><TD WIDTH="33%" ALIGN="left" VALIGN="top" >pg_last_error</TD ><TD WIDTH="34%" ALIGN="center" VALIGN="top" ><A HREF="ref.pgsql.html" ACCESSKEY="U" >Sus</A ></TD ><TD WIDTH="33%" ALIGN="right" VALIGN="top" >pg_last_oid</TD ></TR ></TABLE ></DIV ></BODY ></HTML >