pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Mihail Mihailov <Mihail.Mihailov@uta.fi>
To: pgsql-php@postgresql.org
Subject: Re: phpinfo(): postgresql versions' mismatch
Date: Fri, 09 Feb 2007 19:53:46 +0200
Message-ID: <20070209195346.qlm86chc1u88g84g@imp1.uta.fi> (raw)
In-Reply-To: <20070209145731.GA28879@winnie.fuhr.org>
References: <20070209113129.he36qgs4vthc0o4c@imp3.uta.fi>
	<20070209145731.GA28879@winnie.fuhr.org>

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



view thread (6+ messages)  latest in thread

Message-ID: <20070209195346.qlm86chc1u88g84g@imp1.uta.fi>
Permalink:  ../20070209195346.qlm86chc1u88g84g@imp1.uta.fi/
Also on:    postgresql.org/message-id/20070209195346.qlm86chc1u88g84g@imp1.uta.fi

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-php@postgresql.org
  Cc: Mihail.Mihailov@uta.fi
  Subject: Re: phpinfo(): postgresql versions' mismatch
  In-Reply-To: <20070209195346.qlm86chc1u88g84g@imp1.uta.fi>
  References: <20070209113129.he36qgs4vthc0o4c@imp3.uta.fi> <20070209145731.GA28879@winnie.fuhr.org> <20070209195346.qlm86chc1u88g84g@imp1.uta.fi>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox