From: | Lukas Eder <lukas(dot)eder(at)gmail(dot)com> |
---|---|
To: | Robert Haas <robertmhaas(at)gmail(dot)com> |
Cc: | Oliver Jowett <oliver(at)opencloud(dot)com>, rsmogura <rsmogura(at)softperience(dot)eu>, 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-16 08:30:43 |
Message-ID: | AANLkTikNjPoca5n7CusTEL2GoXNQuZeeF0vyegpsz3UF@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-jdbc |
I'm not trying to fix the signature. I want exactly that signature. I want
to return 1 UDT as an OUT parameter from a function.
Somewhere between JDBC and the database, this signature is lost, and JDBC's
internal code tells me that I have to bind 6 OUT parameters, instead of 1.
It happens to be so, because the UDT contains 6 attributes, so somehow the
JDBC/database protocol flattens the UDT, and I think that's a bug, either in
JDBC or in the protocol or in the database. My findings were that I can
correctly read the UDT OUT parameter using the pgAdmin III tool, so I
excluded the database as a bug holder candidate.
Cheers
Lukas
2011/2/15 Robert Haas <robertmhaas(at)gmail(dot)com>
> On Sat, Feb 12, 2011 at 6:16 AM, Lukas Eder <lukas(dot)eder(at)gmail(dot)com> wrote:
> > I had tried that before. That doesn't seem to change anything. JDBC still
> > expects 6 OUT parameters, instead of just 1...
>
> Oh, hrm. I thought you were trying to fix the return value, rather
> than the signature.
>
> I am not sure how to fix the signature. Can you just make it return
> RECORD?
>
> --
> Robert Haas
> EnterpriseDB: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
>
From | Date | Subject | |
---|---|---|---|
Next Message | Cédric Villemain | 2011-02-16 10:25:40 | Re: why two dashes in extension load files |
Previous Message | Itagaki Takahiro | 2011-02-16 07:48:33 | Re: SQL/MED - file_fdw |
From | Date | Subject | |
---|---|---|---|
Next Message | Lukas Eder | 2011-02-16 09:39:07 | Re: JDBC 4 support |
Previous Message | ml-tb | 2011-02-15 17:08:06 | Issue getColumns(): Nonstandard use of \\ in a string literal |