From: Mihail Mihailov <Mihail.Mihailov@uta.fi>
To: Michael Fuhr <mike@fuhr.org>
Cc: Mihail Mihailov <Mihail.Mihailov@uta.fi>
Cc: pgsql-php@postgresql.org
Subject: Re: phpinfo(): postgresql versions' mismatch
Date: Mon, 12 Feb 2007 08:58:49 +0200
Message-ID: <20070212085849.ts11j575tg6s84o4@imp2.uta.fi> (raw)
In-Reply-To: <20070212031352.GA11669@winnie.fuhr.org>
References: <20070209113129.he36qgs4vthc0o4c@imp3.uta.fi>
<20070209145731.GA28879@winnie.fuhr.org>
<20070209195346.qlm86chc1u88g84g@imp1.uta.fi>
<20070212031352.GA11669@winnie.fuhr.org>
I've checked the script.
It was a bug in the script. Now all the queries work fine.
Sorry for disturbing.
Mihail
Quoting Michael Fuhr <mike@fuhr.org>:
> On Fri, Feb 09, 2007 at 07:53:46PM +0200, Mihail Mihailov wrote:
>> > 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.
>
> Have you turned on statement logging in the database to verify that
> PHP is sending the query you think it is? Have you looked for
> errors in the database logs? What does the PHP code that fetches
> the results look like?
>
>> 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?
>
> Impossible to say without more information. A self-contained test
> case might be useful.
>
>> > 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?
>
> I didn't mean to suggest not using libpq 8.x; I was suggesting that
> you review your queries to make sure you're not depending on implicit
> type casts that PDO's emulated prepared statements might be making
> that will no longer be made with the "real" prepared statements
> that PDO uses when linked against libpq 8.x.
>
> --
> Michael Fuhr
>
--
Mihail Mihailov, lehtori
Käännöstiede (venäjä)
Kieli- ja käännöstieteiden laitos
33014 Tampereen yliopisto
puh. (03) 3551 6123
sähköposti: mihail.mihailov@uta.fi
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, mike@fuhr.org
Subject: Re: phpinfo(): postgresql versions' mismatch
In-Reply-To: <20070212085849.ts11j575tg6s84o4@imp2.uta.fi>
References: <20070209113129.he36qgs4vthc0o4c@imp3.uta.fi> <20070209145731.GA28879@winnie.fuhr.org> <20070209195346.qlm86chc1u88g84g@imp1.uta.fi> <20070212031352.GA11669@winnie.fuhr.org> <20070212085849.ts11j575tg6s84o4@imp2.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