Re: Procedure support improvements

Dave Cramer <[email protected]> Mon, 26 Aug 2019 13:48:23 -0400
Newsgroups gmane.comp.db.postgresql.jdbc
Message-ID <CADK3HH+Bfat=byMsatf9VZ2VcG7Geu7=QJBSbJ8cTeE=sqtkAw@mail.gmail.com>
On Mon, 26 Aug 2019 at 13:43, Laurenz Albe <[email protected]> wrote:

> Dave Cramer wrote:
> > As I said, I'd entertain a connection parameter that switched the
> > CALL to call procedures but ideally you'd complain to the server
> > folks to make Procedures useful.
>
> Apart from the obvious problem that procedures make life hard for the
> JDBC driver, because it does not know if it shall render a call as
> SELECT or CALL:
> What is missing in PostgreSQL procedures to make them useful?
>

being able to use transactions inside a procedure inside a transaction.


Dave Cramer

[email protected]
www.postgresintl.com



>
> Yours,
> Laurenz Albe
>
>