Received: from mail02.peoplesoft.com (mail02.peoplesoft.com [192.206.43.252]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f4OH35A33727 for ; Thu, 24 May 2001 13:03:05 -0400 (EDT) (envelope-from dwilson@mission.net) Received: from utahdemo.corp.peoplesoft.com ([207.135.57.86]) by mail02.peoplesoft.com (8.9.3+Sun/8.9.3) with ESMTP id KAA12252 for ; Thu, 24 May 2001 10:00:16 -0700 (PDT) Received: from dwilsonuta ([207.135.57.82]) by utahdemo.corp.peoplesoft.com with Microsoft SMTPSVC(5.0.2172.1); Thu, 24 May 2001 11:04:08 -0600 Message-ID: <002d01c0e473$8be645b0$523987cf@corp.peoplesoft.com> From: "Dan Wilson" To: "Marc Sherman" , References: Subject: Re: Printing Notices to the web? Date: Thu, 24 May 2001 11:04:08 -0600 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.3018.1300 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.3018.1300 X-OriginalArrivalTime: 24 May 2001 17:04:08.0520 (UTC) FILETIME=[8BDC0C80:01C0E473] X-Archive-Number: 200105/80 X-Sequence-Number: 389 This is an issue with the pgsql PHP extension. There is currently no way to get that info in PHP. Personally, I think there should be a way to retrieve a NOTICE through PHP. Much like the pg_errormessage() function, I think there should be a way to retrieve the NOTICES. This could be very functional for some things. For example, I want to impliment EXPLAIN in phpPgAdmin. I can't because all the EXPLAIN output comes through a NOTICE and their is not way to get to it. Any C/C++ gurus that would be willing to add a function like that to the pgsql module would be my hero! -Dan : Is it possible to have NOTICE messages generated by calls to : pg_exec echoed to the client, like more serious error messages : are? Currently, they're just being logged to syslog by php, : which makes it difficult for me to debug them, since I don't : know which query generated the log message. : : Thanks, : - Marc : : ---------------------------(end of broadcast)--------------------------- : TIP 4: Don't 'kill -9' the postmaster