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

From: rsmogura <rsmogura(at)softperience(dot)eu>
To: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
Cc: Florian Pflug <fgp(at)phlo(dot)org>, Oliver Jowett <oliver(at)opencloud(dot)com>, 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 10:03:18
Message-ID: 6e4f051fab6a5b06c7edc76c2a6466de@mail.softperience.eu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-jdbc

Yes new node should be created and added for 8.x and 9.x releases...

On Thu, 17 Feb 2011 10:53:19 +0100, Pavel Stehule wrote:
> 2011/2/17 Florian Pflug <fgp(at)phlo(dot)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(at)postgresql(dot)org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-hackers
>>

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Oliver Jowett 2011-02-17 10:08:13 Re: Fwd: [JDBC] Weird issues when reading UDT from stored function
Previous Message Andrea Suisani 2011-02-17 09:56:15 Re: Debian readline/libedit breakage

Browse pgsql-jdbc by date

  From Date Subject
Next Message Oliver Jowett 2011-02-17 10:08:13 Re: Fwd: [JDBC] Weird issues when reading UDT from stored function
Previous Message Pavel Stehule 2011-02-17 09:53:19 Re: Fwd: [JDBC] Weird issues when reading UDT from stored function