Re: Fwd: [JDBC] Weird issues when reading UDT from stored function
Pavel Stehule <pavel.stehule@gmail.com>
From: Pavel Stehule <pavel.stehule@gmail.com>
To: rsmogura <rsmogura@softperience.eu>
Cc: Florian Pflug <fgp@phlo.org>, 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-17T10:16:31Z
Lists: pgsql-hackers
2011/2/17 rsmogura <rsmogura@softperience.eu>: > Yes new node should be created and added for 8.x and 9.x releases... what node? Pavel > > On Thu, 17 Feb 2011 10:53:19 +0100, Pavel Stehule wrote: >> >> 2011/2/17 Florian Pflug <fgp@phlo.org>: >>> >>> 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...) >>> >> >> There is only one way - implementation of CALL statement. Any >> emulation on JDBC level is just way to hell. Now, we have to say - >> PostgreSQL doesn't support a CALL statement, support only functions - >> and everybody has to use a different pattern than in other databases. >> Any emulation on JDBC means, it will be slowly, it will be >> unpredictable. >> >> Regards >> >> Pavel Stehule >> >> >>> best regards, >>> Florian Pflug >>> >>> >>> -- >>> Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) >>> To make changes to your subscription: >>> http://www.postgresql.org/mailpref/pgsql-hackers >>> > >