Thanks for your reply, I think I've found the cause. The function just doesn't exist in php 5.0.4. It's in the CVS, we're checking now if it's available in the 5.1b2 release.
This url is a similar discussion where they point to updates in the CVS. http://groups.google.be/group/pgsql.interfaces.php/browse_frm/thread/d3341e51e51094d8/be3c9e252b5ee3fa?q=pg_transaction_status()&rnum=1&hl=nl#be3c9e252b5ee3fa On 7/5/05, Martín Marqués <martin@bugs.unl.edu.ar> wrote: > > 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<http://unl.edu.ar> > ' > Centro de Telematica | DBA, Programador, Administrador > Universidad Nacional > del Litoral > ----------------------------------------------------------------- >
