El Mar 05 Jul 2005 06:33, Jo escribió:
> This sample code (as taken from de documentation):
>    $dbconn = pg_connect("dbname=xxxxx host=xxx.xxx.xxx.xxx user=xxxx 
> password=xxxxxxx") or die("Could not connect");
>    $stat = pg_transaction_status($dbconn);
>    if ($stat === PGSQL_TRANSACTION_UNKNOWN) {
>       echo 'Connection is bad';
>    } else if ($stat === PGSQL_TRANSACTION_IDLE) {
>       echo 'Connection is currently idle';
>    } else {
>       echo 'Connection is in a transaction state';
>    }
> produces the following error:
> Fatal error: Call to undefined function pg_transaction_status() in 
> test.php on line 14

pg_connect seems to work, so I would guess (I haven't install PG8, nor PHP5 
yet) that something in the compiling didn't work properly. Maybe you should 
look for error detecting certain PG components, or see which version of libpq 
it found, and if it is the version on libpq that you installed with PG8.

You don't by the way have another version on PG installed?

> The php manual states the following:
>   Not all functions are supported by all builds. It depends on your 
> libpq (The PostgreSQL C Client interface) version and how libpq is 
> compiled. If there is missing function, libpq does not support the 
> feature required for the function.

Yes, but you have the latest version of libpq (the one that comes with 
PostgreSQL 8.0.0). The only thing that can be happening is that PHP is 
finding another libpq in the way.

> I have installed Postgresql 8.0.0 from source and php 5.0.4 also from 
> source.

Update PostgreSQL to the latest 8.0.x version (lots of bugs were fixed since).

 09:33:15 up 2 days, 18:18,  1 user,  load average: 0.83, 0.70, 0.63
Lic. Martín Marqués   | select 'mmarques' || '@' || 'unl.edu.ar'
Centro de Telematica  |  DBA, Programador, Administrador
             Universidad Nacional
                  del Litoral

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to