Re: [HACKERS] Fwd: Weird issues when reading UDT from stored function - Mailing list pgsql-jdbc

From Pavel Stehule
Subject Re: [HACKERS] Fwd: Weird issues when reading UDT from stored function
Date
Msg-id AANLkTikKU8ZQb9x9jjrvL_MTTHYqvHfwsZ8aOCxVzZO=@mail.gmail.com
Whole thread Raw
In response to Re: [HACKERS] Fwd: Weird issues when reading UDT from stored function  (rsmogura <rsmogura@softperience.eu>)
List pgsql-jdbc
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
>>>
>
>

pgsql-jdbc by date:

Previous
From: Oliver Jowett
Date:
Subject: Re: [HACKERS] Fwd: Weird issues when reading UDT from stored function
Next
From: rsmogura
Date:
Subject: Re: [HACKERS] Fwd: Weird issues when reading UDT from stored function