Hi Michael,
Thanks for comments!
> On Fri, Feb 09, 2007 at 11:31:29AM +0200, Mihail Mihailov wrote:
>> I have recently found out that PHP libpq Version reported by
>> phpinfo() doesn't match the Actual PGSQL Version on the server.
>> I suspect this is the reason why some of postgresql queries do not run
>> via web interface and run without any problem via psql.
>
> Only some PHP queries don't run? What's different about those that
> run and those that don't?
At first everything seemed to work fine. Connection works, queries run.
So far I have found only one query, which worked in postgres 7.4 and
doesn't seem to work now. It is a SELECT query with LIMIT and OFFSET
clauses.
The first query with OFFSET 0 worked, but the second with OFFSET N
returned an empty recordset.
I suspected that it has to do with php because the same query works
fine in psql environment.
> Do the queries that don't run fail with
> an error message? If so, what's the exact message? What do the
> PostgreSQL logs show for the failed queries? You might need to
> adjust settings like log_min_error_statement in postgresql.conf to
> get useful log entries.
Actually, these queries do not fail they just don't return any data.
Do you think it's more likely a bug in the script?
> If you ever upgrade PHP to use 8.x libraries instead of 7.4 libraries,
> beware that some prepared queries that used to work might start
> failing.
So, you think it is not a good idea to make php use the 8.x libpq?
Is the 7.4 libpq quite compatible with postgres 8.1?
Does it affect the speed?
Mihail Mihailov
