Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-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

pgsql-hackers by date

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

pgsql-jdbc by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group