Re: Support for OUT parameters in procedures

Поиск
Список
Период
Сортировка
От Steven Schlansker
Тема Re: Support for OUT parameters in procedures
Дата
Msg-id CAHjY6CUZ-C1ZidTR9FNQtOxYorV9TEZ6=t34kp82_RtUP66k5Q@mail.gmail.com
обсуждение исходный текст
Ответ на Fwd: Support for OUT parameters in procedures  (Dave Cramer <davecramer@postgres.rocks>)
Ответы Re: Support for OUT parameters in procedures  (Dave Cramer <davecramer@postgres.rocks>)
Список 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@postgres.rocks> wrote:
Just saw this on hackers.  Anyon care to comment ?

Dave Cramer
www.postgres.rocks


---------- Forwarded message ---------
From: Robert Haas <robertmhaas@gmail.com>
Date: Fri, 28 Aug 2020 at 09:31
Subject: Re: Support for OUT parameters in procedures
To: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Cc: pgsql-hackers <pgsql-hackers@postgresql.org>


On Fri, Aug 28, 2020 at 2:04 AM Peter Eisentraut
<peter.eisentraut@2ndquadrant.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


В списке pgsql-jdbc по дате отправления:

Предыдущее
От: Dave Cramer
Дата:
Сообщение: Fwd: Support for OUT parameters in procedures
Следующее
От: Dave Cramer
Дата:
Сообщение: Re: Support for OUT parameters in procedures