Re: Stored procedures and out parameters

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Jonathan S(dot) Katz" <jkatz(at)postgresql(dot)org>, Vladimir Sitnikov <sitnikov(dot)vladimir(at)gmail(dot)com>, Merlin Moncure <mmoncure(at)gmail(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>, Dave Cramer <pg(at)fastcrypt(dot)com>, Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>, David G Johnston <david(dot)g(dot)johnston(at)gmail(dot)com>, Shay Rojansky <roji(at)roji(dot)org>, Daniel Verite <daniel(at)manitou-mail(dot)org>, Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Andres Freund <andres(at)anarazel(dot)de>, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
Subject: Re: Stored procedures and out parameters
Date: 2018-09-17 18:27:23
Message-ID: CAFj8pRCxMjv7YNKiRxVdM9W1rbin+sztTduzQ=U9wqpdm=8D_w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

po 17. 9. 2018 v 18:24 odesílatel Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> napsal:

> "Jonathan S. Katz" <jkatz(at)postgresql(dot)org> writes:
> > Just to chime in real quick: from the perspective of the RMT we did not
> > look at these as a series of "right/wrong" options but what would make
> > the most sense for the v11 release so the community could continue to
> > improve support for stored procedures and make it easier for users to
> > work with them going forward.
>
> Yeah. I think the real options we had here were:
>
> 1. Ship v11 with CALL as it stands, try to improve going forward.
> 2. Delay v11 for months while we figure out something better.
> 3. Remove CALL from v11, try again in v12.
>
> Neither #2 nor #3 are at all attractive.
>
> People will need to realize that CALL behavior is still a work in
> progress. That may mean that JDBC etc shouldn't try to support it
> yet, which isn't great, but none of the above options would have
> led to near-term support of CALL in JDBC ...
>

+1

Pavel

> regards, tom lane
>
>

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2018-09-17 18:30:40 Re: pgsql: Allow concurrent-safe open() and fopen() in frontend code for Wi
Previous Message Stephen Frost 2018-09-17 18:09:45 Re: Online verification of checksums