On Thu, Feb 09, 2006 at 12:46:46PM -0300, Alvaro Herrera wrote: > I note in the PHP 4 sources that the PQunescapeBytea function seems to > have been copied there, "for the benefit of PostgreSQL 7.2 users". It > says that it comes from 7.3 but I don't see any sscanf call. > > There is no PQunescapeBytea call in the whole source that I can see, so > my guess is that the libpq function is not called at all. So this may > be a PHP bug rather than a Postgres bug.
The OP claimed to be using PHP 5.1.2, which does have a call to PQunescapeBytea(), although it also has the old code you're seeing and a HAVE_PQUNESCAPEBYTEA macro that determines which to use. Interesting that the command line php and the Apache module behave differently. I wonder if ldd would show the php executable and libphp5.so linked against different versions of libpq; that would add weight to Tom's suggestion that an old libpq might be responsible. -- Michael Fuhr ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match