How to print explain using PHP

On Tue, 9 Jan 2001, Martin A. Marques wrote:

I'm working with PHP and Postgres, and if I try to do an EXPLAIN query, with
PHP, to the postgres backend the output goes to the error_log file of apache
and I don't know how to redirect that output to the browser.

Good point, before some time somebody (Bruce?) ask if anything is
needful add to PostgreSQL extension in PHP. You found that...

PHP not support libpq's routine:

PQnoticeProcessor
PQsetNoticeProcessor( PGconn *conn,
PQnoticeProcessor proc,
void *arg);

Karel

El Mar 09 Ene 2001 16:30, Karel Zak escribi�:

On Tue, 9 Jan 2001, Martin A. Marques wrote:

I'm working with PHP and Postgres, and if I try to do an EXPLAIN query,
with PHP, to the postgres backend the output goes to the error_log file
of apache and I don't know how to redirect that output to the browser.

Good point, before some time somebody (Bruce?) ask if anything is
needful add to PostgreSQL extension in PHP. You found that...

PHP not support libpq's routine:

PQnoticeProcessor
PQsetNoticeProcessor( PGconn *conn,
PQnoticeProcessor proc,
void *arg);

I think it would be of great help for web programers that use postgres. Any
way, I'm doing some messy things to get what I want, but it is a very
needfull extension.

Saludos... :-)

--
System Administration: It's a dirty job,
but someone told I had to do it.
-----------------------------------------------------------------
Mart�n Marqu�s email: martin@math.unl.edu.ar
Santa Fe - Argentina http://math.unl.edu.ar/~martin/
Administrador de sistemas en math.unl.edu.ar
-----------------------------------------------------------------

I think the issue here was that these functions don't make any sense for
PHP because you can't register C functions.

On Tue, 9 Jan 2001, Martin A. Marques wrote:

I'm working with PHP and Postgres, and if I try to do an EXPLAIN query, with
PHP, to the postgres backend the output goes to the error_log file of apache
and I don't know how to redirect that output to the browser.

Good point, before some time somebody (Bruce?) ask if anything is
needful add to PostgreSQL extension in PHP. You found that...

PHP not support libpq's routine:

PQnoticeProcessor
PQsetNoticeProcessor( PGconn *conn,
PQnoticeProcessor proc,
void *arg);

Karel

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

On Tue, 9 Jan 2001, Bruce Momjian wrote:

I think the issue here was that these functions don't make any sense for
PHP because you can't register C functions.

I mean (I know) that you can register some common (internal) PHP
function and this function can call your PHP function. It is some used in
XML Expat parser that use element handlers (functions).

It's very good resolvable in PHP... see php-4.0b3/ext/xml/xml.c as example

Karel

On Tue, 9 Jan 2001, Bruce Momjian wrote:

I think the issue here was that these functions don't make any sense for
PHP because you can't register C functions.

I mean (I know) that you can register some common (internal) PHP
function and this function can call your PHP function. It is some used in
XML Expat parser that use element handlers (functions).

It's very good resolvable in PHP... see php-4.0b3/ext/xml/xml.c as example

OK, this is why I never added it to the TODO list. Should we add this
to our TODO list?

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

On Tue, 9 Jan 2001, Bruce Momjian wrote:

On Tue, 9 Jan 2001, Bruce Momjian wrote:

I think the issue here was that these functions don't make any sense for
PHP because you can't register C functions.

I mean (I know) that you can register some common (internal) PHP
function and this function can call your PHP function. It is some used in
XML Expat parser that use element handlers (functions).

It's very good resolvable in PHP... see php-4.0b3/ext/xml/xml.c as example

OK, this is why I never added it to the TODO list. Should we add this
to our TODO list?

Quick look to PHP:-)

libphp/zend_execute_API.c: call_user_function()

Karel

On Tue, 9 Jan 2001, Bruce Momjian wrote:

I think the issue here was that these functions don't make any sense for
PHP because you can't register C functions.

I mean (I know) that you can register some common (internal) PHP
function and this function can call your PHP function. It is some used in
XML Expat parser that use element handlers (functions).

It's very good resolvable in PHP... see php-4.0b3/ext/xml/xml.c as example

IMHO it would be confusing for PHP users. What about changing the PHP
function php_pgsql_do_connect so that it calls PQsetNoticeProcessor to
preserve the last NOTIFY string somewhere. And we would invent new PHP
function pg_notifymessage (or whatever) to extract the string later on.

OK, this is why I never added it to the TODO list. Should we add this
to our TODO list?

I don't think so, if the TODO should only include things to do with
the PostgreSQL source code.
--
Tatsuo Ishii