Horton

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

Florian G. Pflug <fgp@phlo.org>

View thread
From: Florian Pflug <fgp@phlo.org>
To: rsmogura <rsmogura@softperience.eu>
Cc: Oliver Jowett <oliver@opencloud.com>, Tom Lane <tgl@sss.pgh.pa.us>, Robert Haas <robertmhaas@gmail.com>, Lukas Eder <lukas.eder@gmail.com>, <pgsql-jdbc@postgresql.org>, <pgsql-hackers@postgresql.org>
Date: 2011-02-17T09:39:17Z
Lists: pgsql-hackers 
On Feb17, 2011, at 10:30 , rsmogura wrote:
> When JDBC driver will detect if procedure call statement is created.
> 1. Determine procedure oid - how? procedures may have not qualified name. Is any function on backend that will deal with schema search path? You may need to pass procedure parameters or at least types? or we need to mirror backend code to Java?

That change of getting this correct without help from the backend is exactly zero. (Hint: You need to consider overloaded functions and implicit casts of parameters...)

best regards,
Florian Pflug