Newsgroups: php.internals
Path: news.php.net
Xref: news.php.net php.internals:45755
Mailing-List: contact internals-help@lists.php.net; run by ezmlm
Received-SPF: pass (pb1.pair.com: domain gmail.com designates 72.14.220.155 as permitted sender)
DomainKey-Status: bad
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=subject:from:to:in-reply-to:references:content-type:date:message-id
         :mime-version:x-mailer:content-transfer-encoding;
        b=FhZBxjpQrnhy6Az9fwmpFatkeZgZmLapyAJhhPkGGadR9uc7E0jcNnxhef1TQ3+/sU
         C635lXTVAdTP9IiKDpgKH7HY1GTlHCASkiAEUxDYjBANfkpcPOh4NquAwad2faTb88L8
         HNumuKUCjePxS+fXiS2NLlqcdTpi0OB881cl8=
To: internals@lists.php.net
In-Reply-To: <1255038690.10759.9.camel@samuel-laptop>
References: <1255038690.10759.9.camel@samuel-laptop>
Content-Type: text/plain; charset="UTF-8"
Date: Mon, 12 Oct 2009 19:00:22 +0200
Message-ID: <1255366822.3605.80.camel@samuel-laptop>
Mime-Version: 1.0
Content-Transfer-Encoding: 8bit
Subject: Re: Patch: Use notices in PDO
From: samuel.roze@gmail.com (Samuel ROZE)

Hi,

I'm writing here to take a point about the discussion. On one side, you
want to turn this functionality to a global function, like it is
describe into this patch and on the other side, you said that on MySQL
and Oracle we can get this notices with queries so it is not needed for
them but only for PostgreSQL.

Before continuing every development I want to make like a survey about
what I (or we) will do. Here are my proposals:

1. Make this functionality only for PostgreSQL, with a "pgGetNotices"
function.
2. Continue development for MySQL & Oracle, with the known that if
notices recuperation is enabled, PDO will have to do queries.
3. Let development at this stage waiting that somebody else propose a
notices patch for other Database than PostgreSQL.

Note: For MySQL there'is the mysql_info function
(http://dev.mysql.com/doc/refman/5.1/en/mysql-info.html)

Thanks a lot for your reply.
Samuel.

Le jeudi 08 octobre 2009 à 23:51 +0200, Samuel ROZE a écrit :
> Hi,
> 
> I've make a patch which insert notices concepts to PDO. It create:
> - PDO::noticeInfo() - to be like errorInfo
> - PDO::ATTR_LOG_NOTICES, the name of the PDO parameter
> 	- PDO::NOTICES_FETCH - fetch notices
> 	- PDO::NOTICES_NONE - don't fetch notices
> 
> The notices HashTable is emptied at each queries.
> 
> There is a patch to implements this function into PDO:
> http://www.d-sites.com/wp-content/uploads/2009/10/php-5_3-pdo-notices-managment.patch
> 
> And one other to implements notices recuperation for PostgreSQL:
> http://www.d-sites.com/wp-content/uploads/2009/10/php-5_3-pdo-pgsql-notices-managment.patch
> 
> It can be done for Oracle, i'm sure.
> 
> Thanks for feedbacks.
> Samuel.
>