From: | Robert Haas <robertmhaas(at)gmail(dot)com> |
---|---|
To: | Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com> |
Cc: | pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Support for OUT parameters in procedures |
Date: | 2020-08-28 13:30:46 |
Message-ID: | CA+Tgmoa+A1e0DPhs9DBJ7U5idw7Znigsa5=RNrCMRLdy=5Vj7Q@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-jdbc |
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 | Ranier Vilela | 2020-08-28 13:37:08 | Re: Clang UndefinedBehaviorSanitize (Postgres14) Detected undefined-behavior |
Previous Message | Stephen Frost | 2020-08-28 13:26:45 | Re: New default role- 'pg_read_all_data' |
From | Date | Subject | |
---|---|---|---|
Next Message | Vladimir Sitnikov | 2020-08-28 19:40:25 | [pgjdbc/pgjdbc] c745f4: fix: handle nulls when the following clasess are u... |
Previous Message | Peter Eisentraut | 2020-08-28 06:04:04 | Re: Support for OUT parameters in procedures |