Re: libpq and prepared statements progress for 8.0

From: David Wheeler <david(at)kineticode(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Rudy Lippan <rlippan(at)remotelinux(dot)com>, Greg Stark <gsstark(at)mit(dot)edu>, pgsql-hackers(at)postgresql(dot)org, Greg Sabino Mullane <greg(at)turnstep(dot)com>
Subject: Re: libpq and prepared statements progress for 8.0
Date: 2004-09-17 20:50:09
Message-ID: 29930A62-08EB-11D9-9CAB-000A95B9602E@kineticode.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

On Sep 17, 2004, at 1:32 PM, Tom Lane wrote:

> Well, that's the problem: you can't. The SQL PREPARE command doesn't
> have any provision for dealing with unspecified parameters. I think
> this is reasonable since if it could, it would still have no way to
> tell
> you what it resolved the parameter types as. The shortcoming here is
> really in libpq and not in the backend: the protocol-level Parse
> operation *is* designed to handle this scenario, but libpq isn't
> letting
> you get at it.

Great, thank you, Tom, that's exactly the answer I was looking for. And
if I understand a previous post from you, this functionality should be
added to libpq, but you haven't had time and aren't sure what the API
should look like, anyway, is that correct?

Is this the task labeled "llow libpq to check parameterized data types"
here?:

http://candle.pha.pa.us/cgi-bin/pgopenitems

Regards,

David

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2004-09-17 20:54:49 Re: libpq and prepared statements progress for 8.0
Previous Message Tom Lane 2004-09-17 20:32:50 Re: libpq and prepared statements progress for 8.0

Browse pgsql-patches by date

  From Date Subject
Next Message Tom Lane 2004-09-17 20:54:49 Re: libpq and prepared statements progress for 8.0
Previous Message Tom Lane 2004-09-17 20:32:50 Re: libpq and prepared statements progress for 8.0