From: | Steven Schlansker <stevenschlansker(at)gmail(dot)com> |
---|---|
To: | Dave Cramer <davecramer(at)postgres(dot)rocks> |
Cc: | pgsql-jdbc(at)lists(dot)postgresql(dot)org |
Subject: | Re: Support for OUT parameters in procedures |
Date: | 2020-10-05 16:16:54 |
Message-ID: | CAHjY6CUZ-C1ZidTR9FNQtOxYorV9TEZ6=t34kp82_RtUP66k5Q@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-jdbc |
Jdbi got a feature request for such parameters a while back:
https://github.com/jdbi/jdbi/issues/1606
The user uses Oracle which I don't really care to install. When I tried to
implement the feature using Postgres,
I found the driver support too lacking to proceed.
So there's some interest out there in making it work, and I can volunteer
to at least smoke test it with my test cases...
On Mon, Oct 5, 2020 at 3:54 AM Dave Cramer <davecramer(at)postgres(dot)rocks>
wrote:
> Just saw this on hackers. Anyon care to comment ?
>
> Dave Cramer
> www.postgres.rocks
>
>
> ---------- Forwarded message ---------
> From: Robert Haas <robertmhaas(at)gmail(dot)com>
> Date: Fri, 28 Aug 2020 at 09:31
> Subject: Re: Support for OUT parameters in procedures
> To: Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>
> Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
>
>
> On Fri, Aug 28, 2020 at 2:04 AM Peter Eisentraut
> <peter(dot)eisentraut(at)2ndquadrant(dot)com> wrote:
> > The handling of results of SQL statements executed at the top level
> > (a.k.a. direct SQL) is implementation-specific and varies widely in
> > practice. More interesting in practice, in terms of functionality and
> > also compatibility, are nested calls in PL/pgSQL as well as integration
> > in JDBC.
>
> I agree that driver integration, and in particular JDBC integration,
> is important and needs some thought. I don't think it horribly
> matters, with a feature like this, what shows up when people type
> stuff into psql. Whatever it is, people will get used to it. But when
> they interact through a driver, it's different. It is no good
> inventing things, either in PostgreSQL or in the JDBC driver for
> PostgreSQL, that make PostgreSQL behave differently from every other
> database they use. I don't know exactly how we get to a good outcome
> here, but I think it's worth some careful consideration.
>
> --
> Robert Haas
> EnterpriseDB: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Bharath Rupireddy | 2020-10-05 16:18:19 | Re: Use standard SIGHUP and SIGTERM handlers in autoprewarm module |
Previous Message | Tomas Vondra | 2020-10-05 16:03:55 | Re: [HACKERS] Custom compression methods |
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Cramer | 2020-10-05 16:24:15 | Re: Support for OUT parameters in procedures |
Previous Message | Pavel Stehule | 2020-10-05 11:39:05 | Re: Support for OUT parameters in procedures |