From: | Radosław Smogura <rsmogura(at)softperience(dot)eu> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Maciek Sakrejda <msakrejda(at)truviso(dot)com>, PG Hackers <pgsql-hackers(at)postgresql(dot)org>, PostgreSQL JDBC List <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | Re: [JDBC] JDBC and Binary protocol error, for some statements |
Date: | 2010-11-26 07:37:39 |
Message-ID: | 1b5d82d343b5329d977b587decbe80eb@smogura-softworks.eu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-jdbc |
Thank you, but I think about this last night. Opening unnecessary portals
isn't good idea, similarly sending 2nd describe when statement was
prepared. Currently JDBC drivers doesn't make this. I think better will be
to store what format we had requested on stack, and then coerce those
formats when results are handled.
Kind regards,
Radosław Smogura
On Fri, 26 Nov 2010 01:02:25 -0500, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Maciek Sakrejda <msakrejda(at)truviso(dot)com> writes:
>>> 21:43:02.264 (26) FE=> Describe(statement=S_1)
>> You're still doing the statement-flavor Describe. As Tom pointed out,
>> this won't tell you the result types because it doesn't know them.
>> Actually, technically if you issue a statement-flavor Describe *after*
>> a Bind, the server does have this information, but I'm not surprised
>> that it doesn't send it correctly, since it seems pointless to send
>> the statement variation after already doing a Bind.
>
> In principle you could open more than one Portal off a Statement
> at the same time, so it wouldn't necessarily be well-defined anyway.
>
> regards, tom lane
--
----------
Radosław Smogura
http://www.softperience.eu
From | Date | Subject | |
---|---|---|---|
Next Message | Shigeru HANADA | 2010-11-26 07:55:37 | Re: SQL/MED - core functionality |
Previous Message | Tom Lane | 2010-11-26 06:11:42 | Re: Assertion failure on hot standby |
From | Date | Subject | |
---|---|---|---|
Next Message | Radosław Smogura | 2010-11-26 09:01:24 | Re: [JDBC] JDBC and Binary protocol error, for some statements |
Previous Message | Tom Lane | 2010-11-26 06:02:25 | Re: [JDBC] JDBC and Binary protocol error, for some statements |