Re: BUG? res.next() == false, but psql finds tuples?

From: Palle Girgensohn <girgen(at)pingpong(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pg(at)fastcrypt(dot)com, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: BUG? res.next() == false, but psql finds tuples?
Date: 2005-04-22 22:30:18
Message-ID: 7D160FC0C5EC5E58B87529F6@palle.girgensohn.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc


--On fredag, april 22, 2005 18.24.07 -0400 Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
wrote:

> Palle Girgensohn <girgen(at)pingpong(dot)net> writes:
>> hmmm.... is there any way to use the server's prepared statements from
>> psql?
>
> psql can't use the V3 protocol facilities, which means that you can't
> duplicate the case very closely.
>
> After reading your report this morning, I made a little test program
> using libpq's PQexecParams (basically a quick hack on
> src/test/examples/testlibpq3.c) to duplicate your query. I didn't
> see any misbehavior; so there is some additional triggering condition
> beyond what you've told us.
>
> Given that the query packet looks 100% reasonable by eyeball, it seems
> unlikely that the issue is on the JDBC side (barring obvious snafus such
> as connecting to a different database than psql is talking to). But I
> don't have any data with which to pursue the hypothesis of a server bug.

Hmm, yes, there is indeed one thing I didn't tell you... the server is
patches with my ICU patch. That might be a problem? The patch is at
http://people.freebsd.org/~girgen/postgresql-icu

I'll check modifying testlipg3.c with my server, and see what happens.

/Palle

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Tom Lane 2005-04-22 22:40:33 Re: BUG? res.next() == false, but psql finds tuples?
Previous Message Tom Lane 2005-04-22 22:24:07 Re: BUG? res.next() == false, but psql finds tuples?