Re: Fwd: [JDBC] Weird issues when reading UDT from stored function

From: rsmogura <rsmogura(at)softperience(dot)eu>
To: Oliver Jowett <oliver(at)opencloud(dot)com>
Cc: Florian Pflug <fgp(at)phlo(dot)org>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Robert Haas <robertmhaas(at)gmail(dot)com>, Lukas Eder <lukas(dot)eder(at)gmail(dot)com>, <pgsql-jdbc(at)postgresql(dot)org>, <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Fwd: [JDBC] Weird issues when reading UDT from stored function
Date: 2011-02-17 11:37:38
Message-ID: 90b9defedf07d3c3732025d140897b57@mail.softperience.eu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-jdbc

On Fri, 18 Feb 2011 00:06:22 +1300, Oliver Jowett wrote:
> On 17/02/11 23:18, rsmogura wrote:
>> Yes, but driver checks number of declared out parameters and number
>> of
>> resulted parameters (even check types of those), to prevent
>> programming
>> errors.
>
> And..?
>
> Oliver

And it will throw exception when result will income. If you will remove
this then you will lose check against programming errors, when number of
expected parameters is different that number of actual parameters. Bear
in mind that you will get result set of 6 columns, but only 1 is
expected. I think you can't determine what should be returned and how to
fix result without signature.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2011-02-17 11:41:39 Re: sepgsql contrib module
Previous Message Robert Haas 2011-02-17 11:34:25 Re: btree_gist (was: CommitFest progress - or lack thereof)

Browse pgsql-jdbc by date

  From Date Subject
Next Message Oliver Jowett 2011-02-17 11:44:07 Re: Fwd: [JDBC] Weird issues when reading UDT from stored function
Previous Message Oliver Jowett 2011-02-17 11:06:22 Re: Fwd: [JDBC] Weird issues when reading UDT from stored function